parsing data from cell and saving it to a variable

[mithu81]

Question for your great very smart people.

i have about 300 rows of data in column a

the each cell contains a text line such as
"PPF.MP.001.001.001.002_1-3-2_CA0531_ADD3232 Test 1"

I am trying to Parse out the CA0531 and save it to an array. Each row will have a different number after the CA

I am not sure exactly how to find the CA and then pull the 4 numbers after. Any suggestions?

 

[SteveO59L]

=mid(a1,find("ca",a1),6)

 

[texasalynn]

here is a formula approach

Excel Workbook
	C
14	"PPF.MP.001.001.001.002_1-3-2_CA0531_ADD3232 Test 1"
15	CA0531
Sheet2

 

[SteveO59L]

As an option, use search rather than find if you need to be case sensitive

 

[mithu81]

Awesome thanks so much!