Concatenating Two Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All

I have two columns for addresses - the first columns is the number (ie 33) the second is the address (ie Elm Street) - when I use the concatenate function it brings them together but it displays 33Elm Street. Is there a way that I can have a space between the number then the street name so that the column would have 33 Elm Street?

Thanks
Stephanie
 
Hi
a different alternative
=A1&B1
-----Original Message-----
Dear All,

I have two columns for addresses - the first columns is
Click to expand...
the number (ie 33) the second is the address (ie Elm
Street) - when I use the concatenate function it brings
them together but it displays 33Elm Street. Is there a way
that I can have a space between the number then the street
name so that the column would have 33 Elm Street?
 
Back
Top