maybe you could use:

=a1&" "&b1


The Cable Guy wrote:

I have a spread sheet with street numbers in one column and street name in
another. I would like to merge columns nd import into microsoft trips. How
do I merge the two colmns of data into one column?

--

Dave Peterson