Merge Cells

[Guest]

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.

 

[Frank Kabel]

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

 

[AlfD]

Hi!

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

That word (which is very much a dirty word in many places for very goo
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 (i
you have daisies): joining....

Al

 

[Guest]

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,...)