| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
Extract Part of Sentence for Separate Cell's Value
Hello Gents/Ladies...another question....
I have a cell, C13, that says: Bonus: $4,000 (DEC06). My question: How can I copy just 4,000 from this cell and make K18 say $4,000. FYI, C13 does not always contain this data, just sometimes. I need something that would look for the dollar amount and copy only the dollar amount to K18. Thanks for all your help, I really appreciate your time. :o) Bull |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing Part of a Cell's Content | Excel Worksheet Functions | |||
| How I separate first two letters of the sentence in msexcel | Excel Discussion (Misc queries) | |||
| Extract all letters from a cell sentence | Excel Worksheet Functions | |||
| separate a Capital starting word from a sentence | Excel Worksheet Functions | |||
| Extract the n word of a sentence in a cell | Excel Programming | |||
Threaded Mode
