Thread: Extract Part of Sentence for Separate Cell's Value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Extract Part of Sentence for Separate Cell's Value
Look in the help index for MID and FIND

--
Don Guillett
SalesAid Software

wrote in message
ps.com...
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



Reply With QuoteReply With Quote