| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONCATENATE TWO COLUMNS
Assuming Columns 1 and 2 are Columns A and B, put this formula in a third
column and copy down as needed... =A1&" "&B1 -- Rick (MVP - Excel) "The Cable Guy" wrote in message ... Trying to concatenate two columns eg column 1 column 2 1234 2nd st 2345 3rd st 3456 4th st 4567 5th st |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate info from columns into rows | Excel Discussion (Misc queries) | |||
| concatenate time from 3 columns | Excel Discussion (Misc queries) | |||
| Concatenate Data inn different columns | Excel Discussion (Misc queries) | |||
| Concatenate Four Columns With Seperators | Excel Discussion (Misc queries) | |||
| Concatenate two columns? | Excel Worksheet Functions | |||
Hybrid Mode
