Re: =LEFT Function

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tom (any_at_any.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 11:47:27 -0400

Andy,

I know... that's why I posted this question. Please refer to Frank's or
Dave's response for a working solution.

Tom

"Andy B" <andyb@takethisbitout.dawsons.co.uk> wrote in message
news:eWLQZVzQEHA.3732@TK2MSFTNGP11.phx.gbl...
> Hi
>
> Using your existing formula will pull in all of the digits before the
first
> . If there isn't a . (eg 3 ) then it will give you an error
>
> --
> Andy.
>
>
> "Tom" <any@any.com> wrote in message
> news:OFGa2QzQEHA.1340@TK2MSFTNGP12.phx.gbl...
> > Using the function below will allow me to find the 1st character if
> > separated by a period.
> >
> > =LEFT(A1,FIND(".",A1)-1)
> >
> > For instance, it will provide me the following:
> > 1.1 becomes 1
> > 2.1.1 becomes 2
> >
> > However, if I may have also a single digit that needs to become itself
in
> > the function.
> > 1.1 becomes 1
> > 2.1.1 becomes 2 AND
> > 3 becomes 3
> >
> > How do I modify the "=LEFT(A1,FIND(".",A1)-1)" to pick up all the 3
> previous
> > listed values (1, 2, 3)?
> >
> > Thanks,
> > Tom
> >
> >
> >
>
>

Quantcast