Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to process to parse a text string in column A to extract 2
values and return their product in colunmn B A B 120x150 18000 It gets worse when sometimes in the same Col. A I get 2 sets of 2 values like in the following case 40x40x120x120 16000 First I have to test whether I have to deal with the first or second case but then I get lost in handling the Instr and InstrRev functions to extract each set of values Help appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Parsing / seperating text string in excel cell | Excel Discussion (Misc queries) | |||
extract text from string | Excel Worksheet Functions | |||
Extract Values from a String | Excel Programming | |||
Parsing a text string into separate cells | Excel Worksheet Functions | |||
Parsing Data String from text file line | Excel Programming |