Thread: How to retrieve certain char within a string?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
  
Posts: 1,670
Default How to retrieve certain char within a string?
In cell A1, there is a string "Updated: 2007-06-29 15:45(3)"
If the string in cell A1 contains the key word "Updated", then
retrieve the date "2007-06-29" in cell B1.
Does anyone have any suggestions?
Thank in advance for any suggestions
Eric
Reply With QuoteReply With Quote