| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge Columns
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge Columns
Street number in A1, Street name in B1, Formula in C1 =A1&" "&B1
Copy down as far as you wish "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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge Columns
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. "Ron@Buy" wrote: Street number in A1, Street name in B1, Formula in C1 =A1&" "&B1 Copy down as far as you wish "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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge Columns
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge Columns | Excel Discussion (Misc queries) | |||
| merge columns | New Users to Excel | |||
| Merge columns | Excel Discussion (Misc queries) | |||
| merge columns | Excel Worksheet Functions | |||
| merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
Linear Mode
