Two questions for clarification. First, does the "Condition" text appear in
the cell along with the other text (especially for your Condition A)?
Second, for any given condition, are the number of fields in the "code"
portion fixed? For that last question, I mean as an example, for Condition
A, are there always 5 space delimited sections before the comma and a single
number after the comma. If the sections are in fact fixed for each
condition, is there supposed to be a space in front of the plus sign in the
first Condition E like there is in the second Condition E? If so, please
check your other posted conditions for typos and tell us if there are any...
the "shape" of each condition is important in being able to parse the text
the way you want and any typos will produce incorrect solutions.

--
Rick (MVP - Excel)


"LiAD" wrote in message
...
Afternoon,

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