Reply to thread

Message: [QUOTE="LiAD, post: 13484021"] 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 [/QUOTE]

Verification