Thread: Separate Date from a Text String
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sara sara is offline
external usenet poster
  
Posts: 82
Default Separate Date from a Text String
The data that I have looks like this:
[10/24/10 11:45PM]

And I would like to just get the date like this:

10/24/10

Is there any way to do this in Excel with a formula?

Thanks!!

Sara
Reply With QuoteReply With Quote