Thread: Text to YYYY format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
sojuman sojuman is offline
external usenet poster
  
Posts: 9
Default Text to YYYY format
I have text in column "B" that is formatted YYANNNNN (01B12345). I would
like to change to YYYY (2001) format in column "A".

Thanks
Reply With QuoteReply With Quote