Hi all..
Looking at the attached table, is it possible to split column A into the respective 2 parts so that the outcome for each cell looks like Row 2 column B & C
I have a large pupil SS where I need to split the Class (Column A) into its respective Year and Reg (Column B & C)
Regards
Declan
Looking at the attached table, is it possible to split column A into the respective 2 parts so that the outcome for each cell looks like Row 2 column B & C
I have a large pupil SS where I need to split the Class (Column A) into its respective Year and Reg (Column B & C)
Regards
Declan
temp class.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Class | Year | Reg | |||
2 | 9A | 9 | A | |||
3 | 9B | |||||
4 | 9C | |||||
5 | 9D | |||||
6 | 9E | |||||
7 | 10A | |||||
8 | 10B | |||||
9 | 10C | |||||
10 | 10D | |||||
11 | 10E | |||||
Sheet1 |