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.com/uc?export=do...
Пікірлер: 186
I love how he explains every steps with few words and sharing his file for practice is awesome!
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.
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!
Absolutely one of my favorite channels! Thank you!
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.
Your excel videos are always EXACTLY what I'm looking for! Thank so much :)
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 !!! 🙂
I needed a quick lesson on this and I just like your flow of it. Thanks, an easy subscribe and absolute like!
Thank you for making your tutorials easy to follow!
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!
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.
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.
This is very helpful. Simple and clear. Thank you
Thank you! You saved me so much time researching how to do this :)
I think this is the only video in KZread where I don't see a single dislike. Bravo. Your tutorials are really useful. Thanks.
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!
Thank you so much for such a wonderful tutorial👍👍
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
This is a very useful function for me. Thank you.
Thanks a lot. I've found exactly what I need. great video as usual.
Changed my life and saved me a lot of time. Thank you for your service sir
Very clear and easy understand! Thank you!
Thank you! simple and easy to understand!
Really useful. Thank you for sharing :D
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.
Thanks for this! Forgot how and just couldn't remember no matter how I tried. I'm keeping this one, thank you x
That was amazing!!! Thank you so much!
2nd time I've come back to this video in the past few years.....thanks for sharing!
I cant thank you enough! You have saved me a LOT of time.. THANKS, greetings from Malaysia :)
Thank you so much! very clear explaination 👍👍👍👍👍
Thank for this, it helped me saved a lot of time.
This is explained so perfectly. Great videos.
THANK YOU SO MUCH! you just saved me so much time on a work project today! :)
Thank you technology for teachers and students!!
it is very easy and simpel to understand tq for your explanations
Very helpful , life saver . Thanks !!
VERY Helpful. Thank You.
This was so helpful. Thank you so much.
Lovely, so helpful. Thank you
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.
Thank you so much for your tutorials ! it has hepled resolve a concern. I'm a new follower on your chanel😇
Great, tutorial although I did feel I wanted to fast forward a bit as there was also unrelated parts not related to combining cells. What I would suggest is talking about how to use the combined cell data. If you try and copy out the combined text you will only see the formula. You can do this by copying the column into a text editor and then back into excel. Might be useful for some people (it was me!). Otherwise, this tutorial was just what I needed! Thank you.
Thank you so much Is there is any way for line break as well working with this method?
Thank you very much. Very helpful
Can you explain how to format it further? Looking to put information on different lines. Formatting shipping labels for letter mail.
Very helpful. Thanks for sharing
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!
Thanks for spreading knowledge
You are the BOMB! thanks you!
Thank you. I still watch this all the time for tips when I am lost
Thanks!. Quick and easy!
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
Assalam Alaikum. Sir. You save my whole day. Very help ful. Allah Pak Bless You.😊
Very helpful! Thank you for your video
Thank you, it is really useful!
Thanks for helping me .. this makes my work easier❤
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?
Thank u so much ..hope I could follow ur instruction...
saved my day with this
This is a great help. Thank you.
Thank you! You just saved me from a lot of frustration.
Thank you. Its is a great video. Very helpful
this was exactly what i needed it. Thanks!
Thank you. Awesome video.
big help. Thank You Sir.
Excellent video. Thank you for sharing. :)
Thank you~!! worked very well
thank you for the tip, it really useful !!
Excellent, This is whatI need Thank you sir
Thank you.. very informative
Thanks for the content 🙏
thanks this just helped me alot with a work project
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
this is very helpful. thank you.
thank you so much. big help really♥
Thank you for this. 😊
Just what I need. Thanks so much
i were using the "concatenate" formula but this much easier, thx
İ LOVE İT! Thanks a billion
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.
Very nice 👨🏫📓tutorials keep it up!
Great instructor👍
Thanx, Simply Explained well
Very helpful Thanks
YOU ARE AWESOME!!! THANK YOU!
Amazing videos! Great work keep it up! Would you also consider maybe sharing the data you use on your videos? As, it is quite hard to find a relevant data or even type down what is on your screen? Thanks again!
@techteachersandstudents
4 жыл бұрын
Thanks for your kind comments. I’ve started including practice files in the video descriptions that you can download and work with as you follow along with the videos.
Thank you very much!
Thanks.. worked on Mac too👍
Could you pls make tutorial how to combine data from multiple cells that contain data type of text, date & numeric
So help full thank you
Thank you good sir !
Thank You
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!
Thank u its very useful
Is there a way to add the data from one cell to another without creating a third cell for the sum function?
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?
Thank you so much i found the answer here...
If one cell is with underline and I want to have this underline in combination. what should i do?
Thank you!
very good helped a lot