I will assume you import your data into column A. Beginning in column B
(say row 2) enter the values to look for, e.g. "A=", "a=", ....."X=",
"Z=" should run through column V per your example of "A, a, B, G, g,
H, I, i, L, M, N, n, O, Q, R, S, T, u, U, X, Z".

With your imported data in A3, add a comma at the end of the last entry
(e.g. ....Z=CPIC,X=LB*,*) then in B3 enter this Formula:

=IF(ISERROR(MID($A$3,FIND(B2,$A$3,1)+2,FIND(",",$A $3,FIND(B2,$A$3,1))-(FIND(B2,$A$3,1)+2))),"",MID($A$3,FIND(B2,$A$3,1)+ 2,FIND(",",$A$3,FIND(B2,$A$3,1))-(FIND(B2,$A$3,1)+2)))

This will return "1" (the value of "A=")

copy this to C3 and it will return "5" (the value of "a=")

copy to D3 will return "" (a blank cell as there is no "B=" value)

and so on through V3 which returns "CPIC" (the value of "Z=")

NOTE: you _must_ add the comma to the end of the data string in A3 for
this formula to return the last value in the string!

Does this work for you?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=473754