Thread: How do I grab the date from a text string?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi
 
Posts: n/a
Default How do I grab the date from a text string?

Hi,

Maybe you can use something along the line of: (String in A4)

=DATEVALUE(RIGHT((A4),11))

Regards,
Bondi

Reply With QuoteReply With Quote