Combining Data From Multiple Cells in Excel

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...

[@michaelwalker6598]

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!

[@icu8202]

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

[@mitchellyula4447]

Thank you for this quick and simple explanation. I needed to join to columns together for a "city" and "state" column and this was easy to follow.

[@anantashrestha3166]

I think this is the only video in UA-cam where I don't see a single dislike. Bravo. Your tutorials are really useful. Thanks.

[@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!

[@chriswong8307]

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!

[@tuannuramaninat.m.nawawi5068]

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

[@dekebell3307]

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

[@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 !!! 🙂

[@victoriawilliamson7949]

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.

[@blckwntr]

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.

[@lorinawano2473]

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

[@satishkumarb6689]

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.

[@saifullahmahar3322]

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

[@wjkruger9187]

Changed my life and saved me a lot of time. Thank you for your service sir

[@kaitlynndee1126]

This is explained so perfectly. Great videos.

[@yatinsharma3325]

Thank you technology for teachers and students!!

[@freddiealcala2986]

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

[@antonovkouakouthoussin3660]

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

[@pollywantsacracker9648]

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

[@ssyu1902]

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.

[@sarahwaugh4999]

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

[@shelleys8128]

Your excel videos are always EXACTLY what I'm looking for! Thank so much :)

[@jodicamps5693]

Absolutely one of my favorite channels! Thank you!

[@nursyahindah1674]

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

[@faithrunner9548]

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

[@trulygrace2555]

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

[@sandyr6145]

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.

[@urroyalhynus]

this was exactly what i needed it. Thanks!

[@BruceWayne-dr9zh]

Very nice 👨‍🏫📓tutorials keep it up!

[@tammyrivera7122]

Thank you for making your tutorials easy to follow!

[@basudevjana8786]

Thank you very much. Very helpful

[@FAli7869]

Very helpful , life saver . Thanks !!

[@Tuesdayable]

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

[@Alwayszachariah]

Thank you. Its is a great video. Very helpful

[@vettri5002]

Excellent, This is whatI need Thank you sir

[@mohammedmostafa3768]

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

[@giannariveramichelegibsont2510]

This was so helpful. Thank you so much.

[@saidimayanga6186]

This is very helpful. Simple and clear. Thank you

[@tsob315]

This is a great help. Thank you.

[@honest1966]

Very helpful! Thank you for your video

[@kristinprior8716]

Thank you! You saved me so much time researching how to do this :)

[@madeux324]

Excellent video. Thank you for sharing. :)

[@ellaliu2102]

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]

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

[@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

[@bonabernales.1924]

thank you so much. big help really♥

[@076EROWANI]

Thanks for spreading knowledge

[@TYapril]

Very clear and easy understand! Thank you!

[@omahawarrior4837]

Great instructor👍

[@oliver2wist]

Just what I need. Thanks so much

[@karmjeetsingh4842]

Thanx, Simply Explained well

[@FaysalEasyExcel]

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

[@mphomorifi4888]

thanks this just helped me alot with a work project

[@ibrahimsadeek1554]

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

[@luxcreativegifts]

Thank you! simple and easy to understand!

[@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.

[@SoniaBDorsey]

Thank you for this. 😊

[@mrsperkinsasksWWJD]

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 :)

[@michelledias3972]

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

[@ronnelmacompas1647]

this is very helpful. thank you.

[@shalinialjapur505]

Thank you so much for such a wonderful tutorial👍👍

[@johnmariano47]

I needed a quick lesson on this and I just like your flow of it. Thanks, an easy subscribe and absolute like!

[@mrwoodcat]

THANK YOUUUUUU 😭😭😭

[@luthfysetyawan4606]

Thank you, it is really useful!

[@happychildvisnagar1587]

Thank you so much to explain this in an essay way

[@oyonkazi]

saved my day with this

[@TheAireaidLord]

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

[@raymundgelacio2307]

Very helpful. Thanks for sharing

[@hedwigwendell-crumb91]

This is a very useful function for me. Thank you.

[@samiracohen7144]

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.

[@jessicagodfrey1506]

I need to know this as well.

[@MightyMonarchYTsports]

Thank you.. very informative

[@ahmedkhalifi2356]

thank you for the tip, it really useful !!

[@sespider]

VERY Helpful. Thank You.

[@tadiwanashechangamire4425]

GOD BLESS YOU SIR♥️🔥😭🥰

[@aamirabbas7126]

Lovely, so helpful. Thank you

[@joyceannemacalino2477]

big help. Thank You Sir.

[@Paul-ow9gj]

Thanks!. Quick and easy!

[@digitalwudp]

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.

[@BecauseofHimIlive]

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!

[@ar76812]

Thank you.... From India

[@joshdagostino5600]

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

[@moderndwellingsofGeorgia]

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?

[@ameeraanwer2231]

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 )

[@damascuscode]

You are the BOMB! thanks you!

[@SEVENKEYETNERPRISES]

Love for you ♥

[@MjMojo]

YOU ARE AWESOME!!! THANK YOU!

[@danielzamudio7813]

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

[@SharingTheBliss]

That was amazing!!! Thank you so much!

[@samanthapetersen7058]

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]

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

[@eve832]

Thank you~!! worked very well

[@rohanesarip4673]

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

[@NattyGeek78]

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

[@awchiwawa7850]

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.

[@dodge6888able]

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?

[@jevoymatthews787]

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

[@sunilshetty5052]

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

[@whyteboynation]

well detailed

[@sumeet3462]

Thanks.. worked on Mac too👍

[@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?

[@jamiemorse3804]

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?