How to Combine Data from Multiple Cells in Excel

hi I'm Jamie and welcome to teachers Tech  today I want to show you how you can combine   data from multiple cells into one so this  data could be in the form of text it could   numbers but you can still  put it together in one cell once you have   this formula in place you can copy it right  down let's get started on these step-by-step instructions using any functions like concat  or text joint here today we're going to do a   different approach and the other thing I just want  to point out is I'm keeping this quite simple with   two columns but you can add more columns and then  just continue on with a pattern that I'm showing   you so how we do this is we're going to start with  our equation sign here so our equal sign and we're   going to just select the first cell and then we're  going to use the Ampersand sign which is above   the seven shift seven and now we click on our next  cell and I'm just going to hit enter so as you can   see it's not quite exactly what I showed you in  the intro we need to do a few more things to it so   the first thing that we could do is give a space  in between the r and the three here so we can do   this by going back up to the formula bar up here  so I'm just going to uh go ahead and select here   and I'm going to uh type in uh just the quotation  marks here and I'm going to put a space so I just   hit space bar put another quotation mark and now  I need to add another Ampersand sign and I'm going   to hit enter so by doing that now if I click on  it this space between the quotation marks acts   as the space here so what I if I wanted a dollar  sign on this to where it says the 350,000 I could   go up here and I'm going to place it right here so  I have a space but then I'm going to do my dollar   sign hit enter and now I have a dollar sign right  there I'm going to come back and show you how we   can format this number uh in a bit here but I'm  just going to continue on to show you that we   can add an ampersand sign at the end too so if I  wanted to add that per episode I just can go up to   the top here and this is where I can add another  ersen sign and use when you're typing you need to   use your quotation mark so I'm going to say per  episode but I want a space so I'm going to add   a space first and I'm going to say per episode  uh just like this and I'm going to go quotation   mark and I'm going to hit enter so now I have why  to $350,000 per episode just by using the Amper   Ampersand sign and using the uh the quotation  marks to put spaces now there's something else   I want to do I could copy this all the way down  just by double clicking and filling in but I'm   going to go back one step because I want to add  formatting now so this is a cool part of this   because I want to add a formatting to this 350,000  where I have the comma in the correct spot and I'm   going to have the dollar sign so I'm going to  actually remove the dollar sign from here because   I'm going to use formatting for this and uh what  I'm going to have is uh just go we are going to   use a function too but before I go grab uh put the  function in I'm going to grab some formatting and   to do this you can rightclick anywhere uh in here  so I'm just going to rightclick and I'm going to   go to format cells you can see it right here  and I'll drag this up and where you need to go   to custom uh you can see all the things in here  we're going to actually copy formatting out of   here and so in the case of the number here that  I want in it it's going to be uh it's going to   have a dollar sign I wanted to be formatted  and I wanted to have comma so if I look at   this here this is you can see there's going to be  negative positive how it's going to be formatting   uh I could take the whole thing and move it over  I could just take a chunk so what I'm going to do   is just highlight what I need here and I'm going  to just go contrl C for copy so I'm going to have   this I'm going to hit okay now and a shortcut for  this if I go back to it if I just hit control one   that's the shortcut that will get you there in a  hurry too so two ways to do that uh now if I go   back to this cell I need to add the text function  and where I'm going to add it is before the B2 so   B2 is the number and I'm just going to start by  typing text and you can see the functions come up   and I'm going to just select text it adds the  uh the bracket for me and on this side of the B2   I need to add a comma if you follow along you can  see where it says comma next and I need to add a   quotation mark so I'm going to be pasting in that  information that I copied from the formatting so   I'm going to go contrl V and now I'm going to go  and do another quotation mark to end it and I need   to close my bracket so when I close my bracket  uh I'm just going to go ahead and hit enter and

you can see now this is formatted with a comma  to separate the thousands and it has the dollar   sign in there so at this point I can copy this all  the way down and it copies all the down way down   correctly with the formatting In Here Also I hope  this tip about how to combine data from multiple   cells in Excel has helped you out and you can  start using it right away I just want to point   you towards a different video of mine about how I  show you to format cells that you can put text in   it and still have a working formula with  it so I'll put the link right here thanks   for watching this time on teachers Tech I'll see  you next time with more Tech tips and tutorials