Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tough teaser!
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Real teaser! | Excel Worksheet Functions | |||
Brain Teaser | Excel Discussion (Misc queries) | |||
stock level teaser | Excel Programming | |||
Custom View - TEASER | Excel Programming | |||
Brain teaser | Excel Programming |