Thread: How do you extract day/time/month/year information
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SV[_2_] SV[_2_] is offline
external usenet poster
  
Posts: 5
Default How do you extract day/time/month/year information
Hello,

I came across this issue, where I have a exported excel file. With the
information in a field "Friday 02:15:00 March 2009". I need these
information extracted. I only require Month/Year. I need to end up with a
field with only "March 2009". Is there a formula for this?


Thanks for your help.
Reply With QuoteReply With Quote