Re: =LEFT Function
From: Andy B (andyb_at_takethisbitout.dawsons.co.uk)
Date: 05/26/04
- Next message: Dave R.: "Re: =LEFT Function"
- Previous message: [G]rumpy [O]ld [D]uffer: "Links showing #VALUE!"
- In reply to: Tom: "=LEFT Function"
- Next in thread: Tom: "Re: =LEFT Function"
- Reply: Tom: "Re: =LEFT Function"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 26 May 2004 16:23:04 +0100
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
>
>
>
- Next message: Dave R.: "Re: =LEFT Function"
- Previous message: [G]rumpy [O]ld [D]uffer: "Links showing #VALUE!"
- In reply to: Tom: "=LEFT Function"
- Next in thread: Tom: "Re: =LEFT Function"
- Reply: Tom: "Re: =LEFT Function"
- Messages sorted by: [ date ] [ thread ]
