Merge Columns

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?
 
R

Ron@Buy

Street number in A1, Street name in B1, Formula in C1 =A1&" "&B1
Copy down as far as you wish
 
T

The Cable Guy

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.
 
D

Dave Peterson

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

Merge Cells 3
Merging multiple columns into one column (dynamically) 1
how do i merge the datas in 2 columns 3
importing specific data from one spread sheet into a new spreadshe 7
Word Create a Phone Book using MailMerge in word 2007 0
Merge contents of two columns into one? 3
Want to link a cell of numbers with a cell of text & can sort 1
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6

Top