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 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
Excel function question
1234ah -
ac3mark -

3 responses