Thread: Extract dd and mm from text and put that plus current yy in another
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default Extract dd and mm from text and put that plus current yy in another
Try Text to Columns (in the Data menu). It should convert most every date
for you.

Regards,
Fred

"robzrob" wrote in message
...
I've got a workbook which comes from someone else and it's got a cell
in it from which I want to get the above. The format of the cell
varies. It could be texttexttext 17Feb09, texttexttext 17th Feb,
texttexttext 17 February 09, texttexttext 17th February 2009, etc (but
never Feb 17 - I'm in UK not US!)

Reply With QuoteReply With Quote