Excel Spreadsheet question..

[Tavis]

Does anyone know if there is a way to merge two cells together and keep the text that is in both of the cells? When I try to merge them normally, it only keeps what is in the left cell.

Any help appreciated.

 

[ScoobMaster]

search the help for the "concatenate" function

 

[isasir]

Your best bet is to probably write a formula to concatenate the two cells.

ie: =concatenate(A1," ",B1)

 

[Tavis]

Thanks, looking into that now..

 

[Tavis]

Awesome, works perfectly, thanks!

 

[ScoobMaster]

Glad it worked - happy to help

 

[Tavis]

Hrmm... another question on the same topic.. How can I get each cell to combine with the two cells before it without having to manually type each formula in? Example:

Cell 1 | Cell 2 | Cell 3

Row A abc | 123 | =A1&B1 - which of course we know equals abc123
Row B abd | 321 | = - if i put the same forumla in row b, it will only do cell one and cell 2 from Row A, but I want it to do Row B with the same formula, just with B1&B2..

So my question is, how do I make each formula be just for that row without having to manually enter the formula for each row. Thank you for any assistance!

 

[kranky]

You don't have much experience with Excel, do you?

Select the cell in ROW A that has the formula. It will highlight and in the lower right corner you'll see a small black square. Drag that black square down as many rows as you need. Excel will adjust the references in the formulas for you.

 

[imported_Papi]

Or Cut and Wrap cell and paste text...

 

[Tavis]

Wow.. that was easy.. Thanks.