Thread: How do you extract day/time/month/year information
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How do you extract day/time/month/year information
=MID(A1,FIND(":",A1)+7,99)


"SV" wrote:

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