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

[@icu8202]

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

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

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

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

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

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

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

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

[@lorinawano2473]

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

[@nursyahindah1674]

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

[@yatinsharma3325]

Thank you technology for teachers and students!!

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

[@wjkruger9187]

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

[@dekebell3307]

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

[@basudevjana8786]

Thank you very much. Very helpful

[@tuannuramaninat.m.nawawi5068]

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

[@saifullahmahar3322]

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

[@trulygrace2555]

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

[@freddiealcala2986]

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

[@kaitlynndee1126]

This is explained so perfectly. Great videos.

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

[@pollywantsacracker9648]

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

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

[@FAli7869]

Very helpful , life saver . Thanks !!

[@jodicamps5693]

Absolutely one of my favorite channels! Thank you!

[@rohanesarip4673]

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

[@shelleys8128]

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

[@ar76812]

Thank you.... From India

[@SoniaBDorsey]

Thank you for this. 😊

[@tammyrivera7122]

Thank you for making your tutorials easy to follow!

[@faithrunner9548]

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

[@076EROWANI]

Thanks for spreading knowledge

[@joyceannemacalino2477]

big help. Thank You Sir.

[@lesterdeguzman3905]

Thank you.. very informative

[@urroyalhynus]

this was exactly what i needed it. Thanks!

[@sarahwaugh4999]

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

[@TYapril]

Very clear and easy understand! Thank you!

[@antonovkouakouthoussin3660]

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

[@vettri5002]

Excellent, This is whatI need Thank you sir

[@mitchperko]

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

[@oliver2wist]

Just what I need. Thanks so much

[@saidimayanga6186]

This is very helpful. Simple and clear. Thank you

[@giannariveramichelegibsont2510]

This was so helpful. Thank you so much.

[@ernestcooper3316]

Very helpful thanks

[@luxcreativegifts]

Thank you! simple and easy to understand!

[@oyonkazi]

saved my day with this

[@honest1966]

Very helpful! Thank you for your video

[@tsob315]

This is a great help. Thank you.

[@tajemmanuel1582]

Thank you good sir !

[@karmjeetsingh4842]

Thanx, Simply Explained well

[@Tuesdayable]

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

[@hiranabhishek6832]

Thank you very much!

[@mphomorifi4888]

thanks this just helped me alot with a work project

[@happychildvisnagar1587]

Thank you so much to explain this in an essay way

[@Alwayszachariah]

Thank you. Its is a great video. Very helpful

[@ibrahimsadeek1554]

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

[@farookhummer3608]

So help full thank you

[@thambu7623]

Thank u its very useful

[@raymundgelacio2307]

Very helpful. Thanks for sharing

[@ronnelmacompas1647]

this is very helpful. thank you.

[@BruceWayne-dr9zh]

Very nice 👨‍🏫📓tutorials keep it up!

[@drock1974life]

Thank you. Awesome video.

[@omahawarrior4837]

Great instructor👍

[@hafizzulqurnainarshad7773]

very good helped a lot

[@meseretteklewold3625]

Thank you!

[@aamirabbas7126]

Lovely, so helpful. Thank you

[@sespider]

VERY Helpful. Thank You.

[@Paul-ow9gj]

Thanks!. Quick and easy!

[@bonabernales.1924]

thank you so much. big help really♥

[@damascuscode]

You are the BOMB! thanks you!

[@tizmehere492]

Thank you thank you thank you!

[@mrwoodcat]

THANK YOUUUUUU 😭😭😭

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

[@savageftw]

BRO THANKYOUUUUUU

[@shabrotherss]

Thank You

[@haikalami6581]

Thank you sir❤

[@madeux324]

Excellent video. Thank you for sharing. :)

[@kristinprior8716]

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

[@FaysalEasyExcel]

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

[@MjMojo]

YOU ARE AWESOME!!! THANK YOU!

[@ombikram8614]

Thank you so much...

[@ahmedkhalifi2356]

thank you for the tip, it really useful !!

[@pradipparmar4967]

Omg thank you very much brother

[@hedwigwendell-crumb91]

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

[@eve832]

Thank you~!! worked very well

[@sumeet3462]

Thanks.. worked on Mac too👍

[@whyteboynation]

well detailed

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

[@tadiwanashechangamire4425]

GOD BLESS YOU SIR♥️🔥😭🥰

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

[@user-jc3fb5uh5n]

Love for you ♥

[@cheyenne09ify]

thank you!

[@shalinialjapur505]

Thank you so much for such a wonderful tutorial👍👍

[@mohammedmostafa3768]

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

[@prajjwaldangal2022]

thank you

[@micelblanes6820]

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

[@mcgeorgeadelantar975]

Thanks

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

[@johnmariano47]

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

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