Thread: Date formatting from text
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Date formatting from text
Forgot to add "rd", but you probably caught it...

In article ,
morlo wrote:

works a treat - thanks!

"JE McGimpsey" wrote:

One way:

=--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"st",""),"nd", ""),"th","")

Reply With QuoteReply With Quote