L

#### LiAD

Is it possible some-one could help with a formula to look inside a text

string mixed of letters, numbers and symbols to return a number that

corresponds to a certain character.

Example of character strings to investigate -

Condition A - 42 N 8 FILS 0,50 or 55 N 12 F 0,50 (two ways of writing this

input)

I need a way of outputting the value before and the value after the N into

two separate cells, so outputs would be 42 and 8 or 55 and 12.

Condition B - 27

I just need it to return the same value, (27)

Condition E - 1 T.2.65CU801+ 9 F.1.05

I need this to return the value before the F, (9).

Condition C - 1 T 120 CU 552 + 68 N 12 F 0,50

As per condition 1, return only the value before and after the N in two

separate cells. The first part before the + is to be ignored. Result 68 and

12

Condition D - 37 T 1,91 ET 851

I need this to return a zero (0) as there is nothing i need to know from this.

Condition E - 3 N 8 F 0,30 + 3 F 0,30

I need this to return three values; the two either side of the N, (3 and 8)

and the one before the F, (3).

Condition F - 3 N 7 F 0,40 + 1 N 6 F 0,40

Result required - the value either side of the two N's - 3 and 7 and 1 and 6

This can be achieved either with formulas or code - depending on what is the

easiest to follow, change if desired and takes the least space. I will have

200 such lines to digest.

Does anyone have any ideas on how best to achieve these results from one

column of 200 input cells going straight to 1-4 columns of results?

Thanks

LiAD