Re: Recognising text as data

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 21:08:18 +0200

Hi
try
=--SUBSTITUTE(MID($A$2,FIND("(",$A$2)+1,FIND(")",$A$2)-FIND("(",$A$2)-1
)," ","-") 

--
Regards
Frank Kabel
Frankfurt, Germany
"Grayling" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag
news:250401c4701d$d40052d0$a501280a@phx.gbl...
> Hi.  A2 contains text like this example
>
> "YORK (12 Jun 2004) "
>
> and I extract to a number of P cells the date part ("12
> Jun 2004") using
>
> =MID($A$2,FIND("(",$A$2)+1,FIND(")",$A$2)-FIND("(",$A$2)-
> 1)
>
> The problem for me is that Excel doesn't recognise the P
> cell text (that is, e.g. "12 Jun 2004") as a date, so I
> can't reformat it into another date format and can't sort
> data on the basis of it.  Very grateful for any help with
> this.
>
> Grayling
>
Quantcast