MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Merging cells

Posted by Brendon Sinclair on April 23, 2001 6:28 PM


I have a database on an Excel spreadsheet that I need to import into another program.
As the fields don't match I need to merge some cells.

The most important one is that streetnumber/street name are 2 seperate cells.

Is there anyway to merge these cells and put a space between the street number and street name in the newly merged cell?

Thanks in advance.



Posted by Ian G on April 23, 2001 7:26 PM

Hi Brendon
Assuming the street number is in A1 and the name is in B1, put "=(A1&" "&B1) in C1 and copy down as far as you need. Then select column C, copy and then use paste special\values (on the edit menu) to column C, then delete columns A and B.

Posted by Brendon Sinclair on April 24, 2001 12:09 AM

Thanks Ian

Thanks a bunch Ian

Saved me a big headache.