| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I combine multiple columns into just 1 column?
In my excel file, the address is split into 4 columns. I want to combine the
4 columns into 1. |
|
#2
|
|||
|
|||
|
How do I combine multiple columns into just 1 column?
In a fifth column, use the concanenate function or amphisand to combine the
information. Then drag down to copy for each row. =CONCATENATE(A1,B1,C1,D1) or =A1&B1&C1&D1 HTH "scosus" wrote: In my excel file, the address is split into 4 columns. I want to combine the 4 columns into 1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to merge data from multiple columns to one column | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Combining mutiple columns into one column | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| vlookup for multiple columns | Excel Worksheet Functions | |||
Linear Mode
