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

Merging from an Excel file with graphics 1
Mail Merge Directory Conditional Page Break 0
Windows 2016- Unable to do mail merge with my secondary email accounts 1
Start a mail merge upon opening the document 1
How to display the merge function "url" of a picture? 0
Setting column width in a table with a macro is not working 0
Create a chart from a table in word thats dynamic 0
Mail Merge query 1

Top