Thread: Extract Part of Sentence for Separate Cell's Value
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Extract Part of Sentence for Separate Cell's Value
On 21 Dec 2006 07:38:44 -0800, wrote:

Got it Ron..if the data (i.e. Bonus: $4,000 (DEC06)) is not in the cell
then I would like K18 to say nothing or just ignore C13...I only want
K18 to have $4,000 or whatever dollar amount is listed in C13....

Is this what you mean?

Not exactly. However, you've already responded to Tom that C13 might be empty,
or might contain your text string including a dollar amount.

That being the case, he has supplied you with the appropriate modification of
the formula I supplied.


--ron
Reply With QuoteReply With Quote