Merging more cells into one cell

Solved/Closed
marjean - Aug 7, 2009 at 01:24 AM
 markswan20 - Feb 6, 2013 at 04:19 PM
Hello,

how to merge 3 cells into 1 cell? we tried and tried but we didn't get it.. even the formula, we don't know.. we are just a first timer. we did this...,,, for instance,,

our complete name..

A1 - spears
B1 - britney
C1 - m.

our problem is we don't know how to merge that cells into one cell..???!!!! ;(

please help us as soon as possible!!!.... THANK YOU!!!!

2 replies

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Aug 7, 2009 at 07:21 AM
=A1&" "&B1&", "&C1
15
venkat1926... never knew that it was that easy! Thanks a lot!!!
0
very helpful for me thanks alot @@@@@@@
0
Perhaps one of the easiest and most useful formulas that I have ever needed... Thanks so much
0
Another way to merge, combine or join cells in Excel is using this tool that does the merges without any formulas. You can do it with names, addresses and even make email addresses! http://www.anotherwaytodothis.com/excel-merge/combine-join-cells.php
0
Helped me out today too, thank you very much a++
0
=concatenate(A1,B1,C1)
8
thanks!!!
0
thanks
0
NO IDEA about the concatenate function thanks a lot
0