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
|