Separating Alpha Numeric into 3 cells

[Sabien]

Hello everyone! I have a large data file with the following type of strings:

13G08
13G09
13G10
18C17
18C18
...

I need to separate into 3 columns (A,B,C) like this:
A B C
13 G 08
13 G 09
13 G 10
18 C 17
18 C 18

I know there is probably a good way to do this but I haven't found it yet. Any ideas would be appreciated...

 

[Colin Legg]

If you always want to split it out into :

2 characters - 1 character - 2 characters



You can use the text to columns tool:

• Data > Text To Columns
• Fixed Width > Next
• Left click in the data preview to add "breaks" either side of the 3rd character
• Next
• To preserve leading zeros, select each column in data preview and change the column data format to Text
• Finish

 

[VoG]

If they are always in that format try

Excel Workbook
	A	B	C	D
1	13G08	13	G	08
2	13G09	13	G	09
3	13G10	13	G	10
4	18C17	18	C	17
5	18C18	18	C	18
Sheet1