columns
 

how do you combine column content as in number in address and street name?

columns
 

Do you think "Concatenate" or "&" helps?

Daphtg wrote:
how do you combine column content as in number in address and street name?

--
Message posted via http://www.officekb.com

columns
 

You can combine text (know as concatenating) from two cells (A1 and B1 for
this example) like this...

=A1&" "&B1

Notice concatenated a space in between the text from these two cells in
order to separate them. If you leave that out...

=A1&B1

the text from the two cells will butt up against each other. You can
concatenate multiple cell values and text constants in any order you want.

--
Rick (MVP - Excel)


"Daphtg" wrote in message
...
how do you combine column content as in number in address and street name?

columns
 

Hi,

=A1&", "&B1

This would concatenate the contents of A1 and B1 in a new cell with a comma
and a space between them.

There are few if any reasons to use the CONCATENATION function instead of &.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Daphtg" wrote:

how do you combine column content as in number in address and street name?

columns
 

=A1 & " " & B1 &" " & C1


Gord Dibben MS Excel MVP


On Mon, 31 Aug 2009 12:00:01 -0700, Daphtg
wrote:

how do you combine column content as in number in address and street name?