Merging address cells

C

cp

I created an excel list of addressess, with one column
containing the street number, and an adjacent column
containing the corresponding street name. Is there a way
to merge the two so they end up in a single column? I
then need to import the data into a maping program, which
requires the address and street name to be in on field.

cp
 
B

bigwheel

cp said:
I created an excel list of addressess, with one column
containing the street number, and an adjacent column
containing the corresponding street name. Is there a way
to merge the two so they end up in a single column? I
then need to import the data into a maping program, which
requires the address and street name to be in on field.

cp
Click to expand...

Insert a new column and use this formula :-

=A1&" "&B1
 

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

Word Create a Phone Book using MailMerge in word 2007 0
How do I separate data in address field? 1
Excel merge columns 1
Spread content of 1 cell over many cells 3
Need help with populating a excel workbook 0
How do I separate data in address field? 2
Picking specific records from a table 1
Space in address 4

Top