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!!!!

Merging more cells into one cell
Merging twitter accounts - Guide
Based on the values in cells b77 b88 - Excel Forum
Conditional formatting if cell contains text ✓ - Excel Forum
Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
Excel cell color formula - Guide

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

Ghafud
Aug 7, 2010 at 11:32 PM

venkat1926... never knew that it was that easy! Thanks a lot!!!

Div's
Jan 8, 2011 at 03:16 AM

very helpful for me thanks alot @@@@@@@

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

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