Separate Date from a Text String
hi
assuming your text string is in A2,try this formula,
=MID(A2,2,8)
regards
FSt1
"Sara" wrote:
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
|