I put your text string in A20.

First: in A22:

Returns the G505 under the assumption all of the text structure will be the same and the code (G505) will always be 4 characters.Code:=MID(A20,1+FIND(";",A20),4)

If not, another calculation would have to be done.

Then, I used 2 helper columns.

A B C D 23 X 0.0 72 77 24 X_2 -0.020 83 93 25 Y -0.035 99 107 26 Z 0.05 113 119 27 Z_2 0.005 125 134 Sheet3

Worksheet Formulas

Cell Formula B23 =MID($A$20,C23+LEN(A23)+1,D23-C23-(LEN(A23)+1)) C23 =FIND($A23,$A$20,FIND(":",$A$20)) D23 =FIND("+",$A$20,C23)

## Like this thread? Share it with others