Separate Date from a Text String

[Sara]

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

 

[FSt1]

hi
assuming your text string is in A2,try this formula,

=MID(A2,2,8)

regards
FSt1

 

[T. Valko]

One way...

A1 = [10/24/10 11:45PM]

=--REPLACE(LEFT(A1,FIND(" ",A1)),1,1,"")

Format as Date

 

[Sara]

Thanks so much!!! Exactly the formula I needed.

hi
assuming your text string is in A2,try this formula,

=MID(A2,2,8)

regards
FSt1

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