Combining Data From Multiple Cells in Excel

Поделиться
HTML-код
  • Опубликовано: 1 окт 2024
  • Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Learn how to easily combine information from multiple cells in Excel and then put the resulting combination into a different cell. This is not the same as adding numbers from multiple cells. ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...
    Here's a link to the practice file that goes with the video: drive.google.c...

Комментарии • 191

  • @ellaliu2102
    @ellaliu2102 3 года назад +5

    Thank you for the video! However I have one question: What if the cells I want to combine including the date column? It turned out to be numbers after trying.

    • @charissefeltus516
      @charissefeltus516 2 года назад

      Yes is there an answer? I am trying to use a date also but it is reading as 44799

  • @icu8202
    @icu8202 4 года назад +15

    I love how he explains every steps with few words and sharing his file for practice is awesome!

  • @victoriawilliamson7949
    @victoriawilliamson7949 4 года назад +6

    Thank you so much for this! I was trying to figure out how to combine two columns of names without having to go through all 80 rows and type them one by one.

  • @NattyGeek78
    @NattyGeek78 3 года назад

    Hi!! I have a tricky excel formula that is Messing up. Could you help?

  • @TheAireaidLord
    @TheAireaidLord 4 года назад +1

    How do I make space between my two words? I want one word left aligned and another right aligned. I can't seem to find any tutorial that explains this

  • @michaelwalker6598
    @michaelwalker6598 Год назад +2

    Unreal, cannot thank you enough for that, i spent 30 mins trying to figure it out. Then 2 mins into your video it was done. Legend!

  • @nursyahindah1674
    @nursyahindah1674 4 года назад +1

    it is very easy and simpel to understand tq for your explanations

  • @mitchperko
    @mitchperko 8 месяцев назад

    AND, AS I WROTE THIS, BELOW, 10 MINS AGO, I REALISED THE LANGUAGE TO USE WAS KEEP TEXT REMOVE FORMULAS - SO NOW I HAVE ONE OF THE THREE WAYS TO DO THIS, DOWN! YAYYYYY!
    Hi there,
    Thank you... looks like you are an awesome one for me to follow - that was fantastic. I am soooo new to Excel and trying to learn new skills to save me masses of time in my new career of teaching. I have a dense question... If I had the last name in column A, first in column B, and combined the way you have here with a comma and a space too, as I wanted them spread out like this: Smith, Bob Well, now, I have these in column C - and there is no way for me to use that lovely new list elsewhere as I get warnings, because of course, it's a formula I am trying to copy and paste. Is there a way to just say hey, thanks... now I want that combined surname, the first name on another sheet.... I'll keep playing, but thought I would ask and when I google that question, haha, I get many of these styles of videos only, so maybe there is no way to take the formula out but leave the new data set out pretty :)

  • @basudevjana8786
    @basudevjana8786 3 года назад +1

    Thank you very much. Very helpful

  • @ssyu1902
    @ssyu1902 4 года назад +5

    This is so helpful! Thank you so much for your videos: each one has a topic and very clearly explained. I do enjoy learning Excel with these videos.

  • @DianaJewels
    @DianaJewels Месяц назад

    Thank you very much for the video. ❤ can you please tell us how can we reverse the same like as I have a paragraph and I want to put every sentence in a separate column after every space. Please reply the formula or make a video as I am making a POS system in excel and I want to fetch the multi line data from the barcode🙏🏻 I am waiting

  • @lorinawano2473
    @lorinawano2473 Год назад +1

    Thank for this, it helped me saved a lot of time.

  • @vaseemkhan3856
    @vaseemkhan3856 Месяц назад

    How to put price break up chart for jewellery website in discription column for each product also if possible it should be linked with next coloumns values dynamically in excel.

  • @alwaysindian5999
    @alwaysindian5999 Год назад

    Thanks. But i want numbers without having space. Could you pl. Explain it?

  • @ManojKumar-nl4ut
    @ManojKumar-nl4ut 2 года назад

    Can you please help on limited character to be combine in one cell.. example A1: Anil., B1: Kumar and C1 DOB 13th July.. output should be "anilkuma0713"
    First 4 char of First name + First 4 char of Last name + MMDD

  • @sherrycohen1824
    @sherrycohen1824 2 года назад

    I tried this formula, but it wouldn't pick up the $ sign in front of the value in the final cell. Ugh!

  • @DanielaHristova-j7l
    @DanielaHristova-j7l Год назад

    How can I combine if I have to rows with different amount ? what should be formula? Thank you

  • @sunilshetty5052
    @sunilshetty5052 Год назад

    Sir I want know if 2diffrent date from separate cell to single cell? Plz guide

  • @michelledias3972
    @michelledias3972 4 года назад +3

    I am throughly enjoying all of these tutorials. Do you have a tutorial on combining a lot of data that uses the different symbols? I saw someone use * as x's. Is there a way to know all the different meanings for example what does : mean in this tutorial? I've learned so much in just a few short days thank you so much

  • @samiracohen7144
    @samiracohen7144 3 года назад +2

    Thank you. This is very helpful, but I have a question that goes one step further. What if you enter new data in Row 25? Will Column G automatically fill up without having to drag? This is something Ive been trying to figure out for a long time now. Hope you can help.

  • @Scotty-Z70
    @Scotty-Z70 Год назад

    oh wow!!! I love you!! I've been using Microsoft XL forever...i'm still using my XL97 since....1997...and I have NEVER known this! This is a time saver!

  • @SEVENKEYETNERPRISES
    @SEVENKEYETNERPRISES Год назад +1

    Love for you ♥

  • @SoniaBDorsey
    @SoniaBDorsey 9 месяцев назад

    Thank you for this. 😊

  • @jaghook
    @jaghook Год назад

    hI, I have a problem with this, when i try to work with the results i keep getting a formula to work with,,,,,,,How can i keep the results and get rid of the formulas.

  • @vanessahuerta3235
    @vanessahuerta3235 Год назад

    I have a COUNTIF formula ... now I want to calculate the percentage of a value in that same formula for instance .. it would look like this 500, 19%. I can use what you taught to have a comma and a space .. but what about the calculation of the percentage?

  • @blckwntr
    @blckwntr 4 года назад +6

    Thank you so much for your tutorials! They are helping me with my new job. I was very overwhelmed with Excel but I'm now much more comfortable.

  • @FAli7869
    @FAli7869 3 года назад +1

    Very helpful , life saver . Thanks !!

  • @rohanesarip4673
    @rohanesarip4673 Год назад

    Thank u so much ..hope I could follow ur instruction...

  • @alishaikh4386
    @alishaikh4386 3 года назад

    Doesn't work with numbers with 00 at the beginning of either of the numbers in any cell.
    Eg: 123 and 001
    The formula omits the 00 in the output, any thoughts?

  • @adammalak426
    @adammalak426 2 года назад

    I would like to learn that how can i combine multiple sheet data in one sheet.

  • @muhammadaizat7454
    @muhammadaizat7454 4 года назад

    May i know how to combine all the words and put the sign between it? For example
    Jina pullin: $40, Marcelina Restrepo: $533, Regenia loftis: $172.72 ...

  • @maryarquio8874
    @maryarquio8874 2 года назад

    does not work for me

  • @ameeraanwer2231
    @ameeraanwer2231 2 года назад

    Hi, thanks for the tutorial but i have a doubt. Is there anyway to combine jina (cell First name ) and pullin ( last name ) into Jina pullin in the first name cell itself ??? ( Without using a new cell )

  • @jonathansalazar8465
    @jonathansalazar8465 3 месяца назад

    How to combine A3-A20 and B3-B20 into G3 only?

  • @danielzamudio7813
    @danielzamudio7813 Год назад

    After doing that can you somehow erase the cells from where you grab the data from and just keep the combined ones?

  • @israelmutize2735
    @israelmutize2735 3 года назад

    Hello.
    I have 2 columns with PIN and Serial numbers. I want to combine the two in the form where pin is on top then serial number below but in one cell. I need to do this for like hundreds of cells. How do I do it?

  • @sandyr6145
    @sandyr6145 2 года назад

    Thank you so much for your video! They changed the way we have to do something for work and I couldn't get the text to go to another line in the same cell. Your video saved me :-)
    For MAC users, it would be Option + Enter.

  • @Nevir202
    @Nevir202 Год назад

    Holy cow, can't believe he suggested all those &&&&s instead of just putting &: $&

  • @tuannuramaninat.m.nawawi5068
    @tuannuramaninat.m.nawawi5068 2 года назад

    I cant thank you enough! You have saved me a LOT of time.. THANKS, greetings from Malaysia :)

  • @josephcosgroveF4fl
    @josephcosgroveF4fl 4 года назад

    How could you put color codes in them? For example Jina is a poor costumer (red) compared to Sonia who is a good one (green).
    Anyone?

  • @awchiwawa7850
    @awchiwawa7850 3 года назад

    Hi need help on how to stack phone numbers in 1 column. Like if there are 3 phone numbers per person how I do I make them go underneath each other.

  • @moderndwellingsofGeorgia
    @moderndwellingsofGeorgia 2 года назад

    Let's say I have a list of items with charges for each. But some items are listed multiple times. I would like the multiples to be added together and thus consolidate into one entry on the list. What command could I give excel to add matching items together?

  • @carolee2012
    @carolee2012 4 года назад

    How do I delete the old columns of info after I’ve merged them into a new column? Could you send me to the right video? I’m trying to put city, state, zip together and can do that but want to delete the separate ones and it looks like I get an error! Please help!;)
    Thank you!!

  • @antonovkouakouthoussin3660
    @antonovkouakouthoussin3660 2 года назад

    Thank you so much for your tutorials ! it has hepled resolve a concern. I'm a new follower on your chanel😇

  • @MuMu124
    @MuMu124 3 года назад

    how would you do this from a data entry form, like after i enter the data in the form it automatically puts the data i need to be combined in one column automatically

  • @chriswong8307
    @chriswong8307 4 года назад +1

    this is excellent! you also explained the meaning of & and " ". On lots of blogs or videos, the bloggers or sharers just said you type the & your type the " ". your way is much more easier for us to memorise the format and the ways, especially for the stupid like me. thank you very much!

  • @bonabernales.1924
    @bonabernales.1924 2 года назад

    thank you so much. big help really♥

  • @saifullahmahar3322
    @saifullahmahar3322 2 года назад

    Assalam Alaikum. Sir. You save my whole day. Very help ful. Allah Pak Bless You.😊

  • @suraiyapervin9459
    @suraiyapervin9459 Год назад

    Can you tell me how to link one cell to multiple cells easily?

  • @sarahwaugh4999
    @sarahwaugh4999 2 года назад

    THANK YOU SO MUCH! you just saved me so much time on a work project today! :)

  • @mohammedmostafa3768
    @mohammedmostafa3768 Год назад

    Thank you so much
    Is there is any way for line break as well working with this method?

  • @SoniaRHopewell
    @SoniaRHopewell Год назад

    THANK YOU for this perfectly taught tutorial. I have a question to add to it. Is it possible to put a "return" after each cell? I need to merge 3 cells into one cell... so all 3 lines in one cell but in its own row.

  • @jamiemorse3804
    @jamiemorse3804 3 года назад

    I have a question - when you try and do this with columns D and E you get what is in column E but you do not get the date in column D - instead you get the Julian equivalent - how do you get what is actually in column D?

  • @dekebell3307
    @dekebell3307 11 месяцев назад

    2nd time I've come back to this video in the past few years.....thanks for sharing!

  • @Akolkar2
    @Akolkar2 Год назад

    Pl write syntax while explaining tutorials

  • @damascuscode
    @damascuscode 4 года назад +1

    You are the BOMB! thanks you!

  • @johnhickssr.4915
    @johnhickssr.4915 4 года назад

    The auto fill did not work for me. It just copied the contents of the top cell.

  • @pollywantsacracker9648
    @pollywantsacracker9648 2 года назад

    Thanks for this! Forgot how and just couldn't remember no matter how I tried. I'm keeping this one, thank you x

  • @BecauseofHimIlive
    @BecauseofHimIlive 2 года назад

    Thanks for the video! I've been googling how to combine data into one cell AND add line breaks. Some sites say that adding CHAR(10) into the CONACT formula adds a line break but it's not working for me. Any thoughts? Thanks!

  • @madeux324
    @madeux324 2 года назад

    Excellent video. Thank you for sharing. :)

  • @Alwayszachariah
    @Alwayszachariah Год назад

    Thank you. Its is a great video. Very helpful

  • @satishkumarb6689
    @satishkumarb6689 3 года назад +1

    Thank you so much for your tutorials! This helped me very much. I was very overwhelmed with Excel but I'm now much more comfortable.

  • @Tuesdayable
    @Tuesdayable 4 года назад

    Thank you so much! very clear explaination 👍👍👍👍👍

  • @jevoymatthews787
    @jevoymatthews787 3 года назад

    THANKS SO MUCH:) HOW CAN COPY AND PLACE THE CELL IN ANOTHER SHEET

  • @MightyMonarchYTsports
    @MightyMonarchYTsports Год назад

    Thank you.. very informative

  • @BruceWayne-dr9zh
    @BruceWayne-dr9zh 3 года назад

    Very nice 👨‍🏫📓tutorials keep it up!

  • @jodicamps5693
    @jodicamps5693 4 года назад +2

    Absolutely one of my favorite channels! Thank you!

  • @vettri5002
    @vettri5002 7 месяцев назад

    Excellent, This is whatI need Thank you sir

  • @jevoymatthews787
    @jevoymatthews787 3 года назад

    THANKS SO MUCH:) HOW CAN COPY AND PLACE THE CELL IN ANOTHER SHEET

  • @sonetteeguia265
    @sonetteeguia265 3 года назад

    Hi how to add letter before the combined text in that specific cell

  • @faithrunner9548
    @faithrunner9548 Год назад

    Thanks for helping me .. this makes my work easier❤

  • @joshdagostino5600
    @joshdagostino5600 4 года назад

    Can you explain how to format it further? Looking to put information on different lines. Formatting shipping labels for letter mail.

  • @afrin2001
    @afrin2001 2 месяца назад

    Why not just copy the columns and then merge ..?

  • @pradipparmar4967
    @pradipparmar4967 2 года назад

    Omg thank you very much brother

  • @freddiealcala2986
    @freddiealcala2986 Год назад

    Thank you! You just saved me from a lot of frustration.

  • @ibrahimsadeek1554
    @ibrahimsadeek1554 3 года назад

    i were using the "concatenate" formula but this much easier, thx

  • @FaysalEasyExcel
    @FaysalEasyExcel 2 года назад

    Thanks a lot. I've found exactly what I need. great video as usual.

  • @mphomorifi4888
    @mphomorifi4888 Год назад

    thanks this just helped me alot with a work project

  • @danishah4803
    @danishah4803 2 года назад

    Simply use concatenate function

  • @tadiwanashechangamire4425
    @tadiwanashechangamire4425 2 года назад

    GOD BLESS YOU SIR♥️🔥😭🥰

  • @trulygrace2555
    @trulygrace2555 3 года назад

    Thank you. I still watch this all the time for tips when I am lost

  • @sethmaclean3668
    @sethmaclean3668 4 года назад

    Is there a way to add the data from one cell to another without creating a third cell for the sum function?

  • @Fida7648
    @Fida7648 4 года назад

    Could you pls make tutorial how to combine data from multiple cells that contain data type of text, date & numeric

  • @nannakachandaneswari8696
    @nannakachandaneswari8696 4 года назад

    This is excellent really helpful.
    What should we do when we have 500,000 rows, we cannot drag through all the rows .Is there any other solution for this??

    • @ibrahimsadeek1554
      @ibrahimsadeek1554 3 года назад +1

      double click on the autofill handle it will do it automatically without dragging

  • @kaitlynndee1126
    @kaitlynndee1126 11 месяцев назад

    This is explained so perfectly. Great videos.

  • @yatinsharma3325
    @yatinsharma3325 4 месяца назад

    Thank you technology for teachers and students!!

  • @samanthapetersen7058
    @samanthapetersen7058 2 года назад

    This helped me greatly!! One question, for my first few rows, it perfectly spaced everything ( I combined 7 rows), but for many of the rows, it created these massive spaces. Any idea what could be causing that? Thanks!!

    • @samanthapetersen7058
      @samanthapetersen7058 2 года назад

      never, I figured it out! there were trailing spaces! thanks for this vid!

  • @MAHARANITOO
    @MAHARANITOO Год назад

    Thank you, thank you thank you!!! A great and simple explanation. You remind me of a Maths teacher I once had, who made everything make sense. Not all teachers should be teachers..... You are doing a Fantastic Job!! A Big thumbs up from me and I have subscribed for more !!! 🙂

  • @oyonkazi
    @oyonkazi 4 года назад +1

    saved my day with this

  • @honest1966
    @honest1966 8 месяцев назад

    Very helpful! Thank you for your video

  • @happychildvisnagar1587
    @happychildvisnagar1587 2 года назад

    Thank you so much to explain this in an essay way

  • @Manchitre-Vromon
    @Manchitre-Vromon 3 года назад

    Thanks

  • @micelblanes6820
    @micelblanes6820 3 года назад

    Thank you so much i found the answer here...

  • @mrwoodcat
    @mrwoodcat 2 года назад

    THANK YOUUUUUU 😭😭😭

  • @tizmehere492
    @tizmehere492 3 года назад

    Thank you thank you thank you!

  • @ahmedkhalifi2356
    @ahmedkhalifi2356 Год назад

    thank you for the tip, it really useful !!

  • @annienorman4692
    @annienorman4692 3 года назад

    what is the best way to memorize the formular?

  • @thambu7623
    @thambu7623 7 месяцев назад

    Thank u its very useful

  • @fredbermudezbus2714
    @fredbermudezbus2714 2 года назад

    I cannnot get this to work

  • @dodge6888able
    @dodge6888able 4 года назад

    hi there -- do you have a tutorial on how to add several cells' figures and have that sum automatically populate a single cell on another worksheet within the same file?