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. |
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. |
All times are GMT +1. The time now is 02:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com