Concatenating Two Columns

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
 
F

Frank Kabel

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to combine two columns? 1
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
Word Create a Phone Book using MailMerge in word 2007 0
How to combine two columns into a new column 2
Comparing/Matching two columns 4
Separate address numbers from street name 4
How do I combine two EXCEL columns? 4
Extracting Address data from single cells 2

Top