Combine 2 cells without using the CONCATENATE function

[Guest]

Help.
I am importing .xls information into a custom / proprietary contact manager
system.
Problem is the Excel address information comes in 2 columns 1) the house
number and 2) the street address. If I combine the columns using the
CONCATENATE formula, the import does not work correctly. Is there a way to
actually Move the cell information and combine them? Is there a Macro guru
out there with a great answer? Any Help?

 

[Peo Sjoblom]

What if you concatenate them as you want, then copy them and paste special
as values in place and then delete the original 2 columns?

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Guest]

I actually thought I tried this, but it looks like this will work perfect.
Thanks a lot for your answer.