Seperating multiple text from a string

[wisemank]

Hi there,

I have a many text strings in column A (example: ADA,AGF,AHC,AJB,CLF,LNJ,MRT,NFX,RA4,RC3,RH1,XAC,XB9,XFH,XMF).

I want to separate each three digit codes into many separate columns. So starting in column A1 is the string and B1 would be ADA, C1 would be AGF, D1 would be AHC etc...

Any ideas?

Kip

 

[tybaltlives]

Can you use the "Text to Columns" feature (comma delimited) found on the Data section of the ribbon?

 

[tybaltlives]

or here is a formula way to do it. It assumes that there are no spaces in the original string and that the fragments you are separating are 3-characters long.

Excel 2010
	A	B	C	D
1	ADA,AGF,AHC,AJB,CLF,LNJ,MRT,NFX,RA4,RC3,RH1,XAC,XB9,XFH,XMF	ADA	AGF	AHC
Sheet8

Cell Formulas
Range	Formula
B1	=LEFT(A1,3)
C1	=MID($A1, FIND(CHAR(1),SUBSTITUTE($A1,",",CHAR(1),COLUMN()-2)) +1,3)
D1	=MID($A1, FIND(CHAR(1),SUBSTITUTE($A1,",",CHAR(1),COLUMN()-2)) +1,3)