Re: =LEFT Function
From: Dave R. (daverx_at_hotmail.com)
Date: 05/26/04
- Next message: Dave Gremaud: "SUMIF(AND) FUNCTION"
- Previous message: Andy B: "Re: =LEFT Function"
- 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 08:24:32 -0700
=IF(ISNUMBER(FIND(".",A1)),--LEFT(A1,FIND(".",A1)-1),--A1)
that should work; it converts all numbers to values also. If you have mix of
alpha and numbers, remove the --s.
"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 Gremaud: "SUMIF(AND) FUNCTION"
- Previous message: Andy B: "Re: =LEFT Function"
- In reply to: Tom: "=LEFT Function"
- Next in thread: Tom: "Re: =LEFT Function"
- Reply: Tom: "Re: =LEFT Function"
- Messages sorted by: [ date ] [ thread ]
