Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you combine two columns to one?
I have a column of address numbers that needs to combine with street names so
that I have a combined column of a complete address. Example - What I have in column A is "24513" and in column B I have "Main Street". So I need to combine all of column A with all of column B so that all the addresses appear in one column as "24513 Main Street" |
#2
|
|||
|
|||
Try this in C1:
=A1&" "&B1 HTH Jason Atlanta, GA -----Original Message----- I have a column of address numbers that needs to combine with street names so that I have a combined column of a complete address. Example - What I have in column A is "24513" and in column B I have "Main Street". So I need to combine all of column A with all of column B so that all the addresses appear in one column as "24513 Main Street" . |
#3
|
|||
|
|||
Hi
=A2&" "&B2 regards Peter "StTrumpet" wrote: I have a column of address numbers that needs to combine with street names so that I have a combined column of a complete address. Example - What I have in column A is "24513" and in column B I have "Main Street". So I need to combine all of column A with all of column B so that all the addresses appear in one column as "24513 Main Street" |
#4
|
|||
|
|||
Try...
B1, copied down: =A1&" "&B1 Hope this helps! In article , StTrumpet wrote: I have a column of address numbers that needs to combine with street names so that I have a combined column of a complete address. Example - What I have in column A is "24513" and in column B I have "Main Street". So I need to combine all of column A with all of column B so that all the addresses appear in one column as "24513 Main Street" |
#5
|
|||
|
|||
Correction, that should be...
C1, copied down: =A1&" "&B1 Hope this helps! In article , Domenic wrote: Try... B1, copied down: =A1&" "&B1 Hope this helps! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combine columns | Excel Worksheet Functions | |||
print excel columns on less pages | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
how do i combine columns in excel | Excel Discussion (Misc queries) |