Previous Topic Next Topic

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

Answer 1 / 2
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
Ghafud
Aug 7, 2010 at 11:32 PM
venkat1926... never knew that it was that easy! Thanks a lot!!!
0
Div's
Jan 8, 2011 at 03:16 AM
very helpful for me thanks alot @@@@@@@
0
Alexei
Apr 20, 2011 at 06:23 PM
Perhaps one of the easiest and most useful formulas that I have ever needed... Thanks so much
0
excel_merge
Jan 29, 2013 at 12:59 PM
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
markswan20
Feb 6, 2013 at 04:19 PM
Helped me out today too, thank you very much a++
0
Answer 2 / 2
excel lover4
Apr 7, 2010 at 05:52 AM
=concatenate(A1,B1,C1)
8
Ghafud
Aug 7, 2010 at 11:36 PM
thanks!!!
0
no
Jan 8, 2011 at 03:15 AM
thanks
0
ss
Jan 20, 2013 at 10:42 PM
NO IDEA about the concatenate function thanks a lot
0