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

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"September21" <September21@discussions.microsoft.com> wrote in message
news:61F9F36A-0F6E-43ED-B282-165614AB03B5@microsoft.com...
> 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?
>