[SOLVED] check if the text string start with a specific character

Hi,
I want to know how do I check if the text string starts with a specific
character in if statement.

I used ...
=IF(ISNUMBER(FIND("v",'A2)),"OK","Not OK")

But, the result for this argument returns the text string which includes "v"
anywhere in the text string.
I just want to the text string which begins with "v".

How can I make it?

Try: =IF(LEFT(TRIM(A2),1)="v","OK","Not OK")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"September21" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> I want to know how do I check if the text string starts with a specific
> character in if statement.
>
> I used ...
> =IF(ISNUMBER(FIND("v",'A2)),"OK","Not OK")
>
> But, the result for this argument returns the text string which includes
"v"
> anywhere in the text string.
> I just want to the text string which begins with "v".
>
> How can I make it?
>

=IF(LEFT(A2,1)="v","OK","Not OK")

Vaya con Dios,
Chuck, CABGx3


"September21" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> I want to know how do I check if the text string starts with a specific
> character in if statement.
>
> I used ...
> =IF(ISNUMBER(FIND("v",'A2)),"OK","Not OK")
>
> But, the result for this argument returns the text string which includes
"v"
> anywhere in the text string.
> I just want to the text string which begins with "v".
>
> How can I make it?
>

Thank you very much for your help!


"Max" wrote:

> Try: =IF(LEFT(TRIM(A2),1)="v","OK","Not OK")
>
> --
> Rgds
> Max
> xl 97
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
> "September21" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> > I want to know how do I check if the text string starts with a specific
> > character in if statement.
> >
> > I used ...
> > =IF(ISNUMBER(FIND("v",'A2)),"OK","Not OK")
> >
> > But, the result for this argument returns the text string which includes
> "v"
> > anywhere in the text string.
> > I just want to the text string which begins with "v".
> >
> > How can I make it?
> >
>
>
>

Thank you very much for your help!

"CLR" wrote:

> =IF(LEFT(A2,1)="v","OK","Not OK")
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "September21" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> > I want to know how do I check if the text string starts with a specific
> > character in if statement.
> >
> > I used ...
> > =IF(ISNUMBER(FIND("v",'A2)),"OK","Not OK")
> >
> > But, the result for this argument returns the text string which includes
> "v"
> > anywhere in the text string.
> > I just want to the text string which begins with "v".
> >
> > How can I make it?
> >
>
>
>

You're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"September21" <[email protected]> wrote in message
news:[email protected]...
> Thank you very much for your help!