Prev: Formulas
Next: Find the last number in a row
From: Sara on 18 May 2010 10:18
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
From: FSt1 on 18 May 2010 10:28
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
From: T. Valko on 18 May 2010 10:33
One way...

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

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

Format as Date

--
Biff
Microsoft Excel MVP


"Sara" <Sara(a)discussions.microsoft.com> wrote in message
news:BB50A98D-A6D2-49CB-85AF-716CBB69CB6B(a)microsoft.com...
> 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


From: Sara on 18 May 2010 10:41
Thanks so much!!! Exactly the formula I needed.

"FSt1" wrote:

> 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
 | 
Pages: 1
Prev: Formulas
Next: Find the last number in a row