Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complicated extraction of text
Hi Everyone,
I have a column of cells containing descriptions of some items (in Sheet1, Cell B2 downwards), that looks like this: BLUE GC 201c RED GW 23c GREEN9c GCBROWN12c I need to extract the cell and put my results in 2 fields. The 1st (result) field should have value like: BLUE RED GREEN BROWN For the above results to appear, i have to lookup on whether these colors exist in Sheet2!A1:A12 For the second (result) field, the expected fields a 201C 023C 009C 012C As you can see, i can't think of any logic to cater for this, especially to get the second result because the description contains too many variable instances. Any help would be appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shade cell according to text? | Excel Discussion (Misc queries) | |||
Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |