#### matt-gilbert

##### Member

I have been given code numbers similar to above and need to extract the alpha and numeric characters separately. Examples of code numbers as follows;

A1.1

A10.1

A10.10

AB1.1

AB10.1

AB10.10

As you can see each field is not fixed so the formula needs to adapt to suit. I have used the following formula to drop the alpha but this still does not do what I want

=TRIM(REPLACE(A1,1,LEN(TRIM(LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))-1))),""))

I will need 3 separate formulas so that results are in 3 different cells.

Any help would be appreciated. Thanks. Matt