Merge Columns

  • Thread starter Thread starter The Cable Guy
  • Start date Start date
T

The Cable Guy

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?
 
Street number in A1, Street name in B1, Formula in C1 =A1&" "&B1
Copy down as far as you wish
 
Thank You - However the data is all ready in a spred sheet of about 800
addresses and I am trying to merge the pre existing data.
 
maybe you could use:

=a1&" "&b1

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?
Click to expand...
 

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

help on a vlookup please 5
Merging multiple columns into one column (dynamically) 1
Merge Cells 3
mail merging filtered records..! 0
sorting two columns of merged cells 1
Word Create a Phone Book using MailMerge in word 2007 0
importing specific data from one spread sheet into a new spreadshe 7
how do i merge the datas in 2 columns 3

Back
Top