Combine columns of data into one
Hi, I want to combine columns of data into one, e.g.
to combine column 1, 2 and 3 into column 4 column 1 column 2 column 3 column 4 1 a i 1 2 b ii a 3 c iii i 4 d iv 2 5 e v b 6 f vi ii 7 g vii 3 .... Thanks in advance. |
Combine columns of data into one
I should put the message under other catergory. Sorry about that. |
Combine columns of data into one
In your empyt column:
= A1 & B1 & C1 & ....... If you want a space or character in between: = A1 & "-" & B1 & "-" & C1 & "-" & ....... Thanks, Roger "Naruto" wrote: Hi, I want to combine columns of data into one, e.g. to combine column 1, 2 and 3 into column 4 column 1 column 2 column 3 column 4 1 a i 1 2 b ii a 3 c iii i 4 d iv 2 5 e v b 6 f vi ii 7 g vii 3 ... Thanks in advance. |
All times are GMT +1. The time now is 03:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com