Merge Cells

How do I merge multiple cells into one cell.

I had addresses that I needed to split the house number up
from the street address, so I used "Text to columns" and
now I need to merge my street adresses back together so
the name of the street will be in 1 column instead of
spread out over 3 or 4 columns.

Hi
use something like
=A1 & " " & B1 & " " & C1

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
How do I merge multiple cells into one cell.

I had addresses that I needed to split the house number up
from the street address, so I used "Text to columns" and
now I need to merge my street adresses back together so
the name of the street will be in 1 column instead of
spread out over 3 or 4 columns.

Hi!

Crucially, don't describe it as "merge".

That word (which is very much a dirty word in many places for very good
reasons) describes cell formatting.
What you are doing is CONCATENATING data.

Shall I do the rest of the lecture? OK: go on. Well, I will.

Latin catena: a chain. Stringing together: linking: daisy-chaining (if
you have daisies): joining....

Alf


---
Message posted from http://www.ExcelForum.com/

You can also use the Concatenate worksheet function, to put a space between the street number and street name use this in the formula: text1," ",text2

if needed after using the concatenate function use copy, paste special, value to remove the formula and keep the data combined.

=CONCATENATE (text1,text2,...)



"Frank Kabel" wrote:

Hi
use something like
=A1 & " " & B1 & " " & C1

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
How do I merge multiple cells into one cell.

I had addresses that I needed to split the house number up
from the street address, so I used "Text to columns" and
now I need to merge my street adresses back together so
the name of the street will be in 1 column instead of
spread out over 3 or 4 columns.

Two method:
1. Please input a formula into a new cell like this "=a1 & a2 & .....".
2. Use a third party tool to safety merge cells with with keeping all of
multiple data values. You could download this software from
http://addintools.com.