| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find $ in a string of text and return numbers
In a string of text I need to find the first occurrence of a $ (there will
only be one $ in each string) and then return the numbers after the dollar sign until the first space. Samples: 1.) E-100 Inventory €“ approved $42,000 (bc 9.32) 2.) E-1700 Inventory €“ signage $7,000 September 2006 Results: 42,000 7,000 -- Thanks! Craig |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to find replace text or symbol with carriage return | New Users to Excel | |||
| find text in a string formula | Excel Worksheet Functions | |||
| Get different numbers to return text?? | Excel Worksheet Functions | |||
| Help - Separating numbers appearing on the right of a text string | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Threaded Mode
