Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to combine two columns?
I have received an EXCEL file that has two columns containing address
information. One column has the street number (for instance 6, 123, etc.) and the second column has the Street name (Main, Elm, etc.) In Excel 2003, how can I combine these two columns into one column to give me, in the one column: 6 Main St. 123 Elm St. |
#2
|
|||
|
|||
in a new column, use the formula: =A1&" "&B1 which will give you a join of
the two coumns with a space between the number and street name. LAT "Robert Judge" wrote: I have received an EXCEL file that has two columns containing address information. One column has the street number (for instance 6, 123, etc.) and the second column has the Street name (Main, Elm, etc.) In Excel 2003, how can I combine these two columns into one column to give me, in the one column: 6 Main St. 123 Elm St. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I combine two forms with different size columns to make on. | Excel Discussion (Misc queries) | |||
How do you combine two columns to one? Help!!!!!! | Excel Discussion (Misc queries) | |||
How do you combine two columns to one? | Excel Discussion (Misc queries) | |||
combine columns | Excel Worksheet Functions | |||
how do i combine columns in excel | Excel Discussion (Misc queries) |