Combining Data From Multiple Cells in Excel 

Just what I need. Thanks so much

Lovely, so helpful. Thank you

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.

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

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.

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

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

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

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!

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.

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

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

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

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

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

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

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.

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.

Thank you very much. Very helpful

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

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

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

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

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

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

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.

does not work for me

Love for you ♥

Thank you for this. 😊

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.

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. big help really♥

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

Very helpful , life saver . Thanks !!

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!

Pl write syntax while explaining tutorials

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?

Absolutely one of my favorite channels! Thank you!

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

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?

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

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

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!

You are the BOMB! thanks you!

Thank you.. very informative

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

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.

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

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 )

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.

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.

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

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

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

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

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

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?

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

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

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.

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?

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?

Excellent video. Thank you for sharing. :)

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

Omg thank you very much brother

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

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

Thank you. Its is a great video. Very helpful

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?

GOD BLESS YOU SIR♥️🔥😭🥰

Simply use concatenate function

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

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

Excellent, This is whatI need Thank you sir

Very nice 👨‍🏫📓tutorials keep it up!

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

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

Very helpful, but if you can add the serial number to the tutorials in the titles so we can go one by one in sequence.

If one cell is with underline and I want to have this underline in combination. what should i do?

Thank u its very useful

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?

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

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

Thank you technology for teachers and students!!

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

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

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

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

This is explained so perfectly. Great videos.

saved my day with this

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

thanks this just helped me alot with a work project

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

Very helpful thanks

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

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

same story everytime, works for everyone but me

Thank you very much!

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

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