Data Validation Must Contains mark ' (approstrops) in Left

[muhammad susanto]

hi all,

i need your help how create data validation with criteria :
- start mark ' (approstrops) in left position like example this below :

'6136716
'981289
'2091234
etc...

i have using formula =LEFT(B3)="'", but still not working...

any help me, thanks in advance...

m.susanto

 

[muhammad susanto]

hi m fexcel, thank for your suggestion, it's help me..

thanks a lot....

 

[mfexcel]

You are welcome. Glad it helps

hi m fexcel, thank for your suggestion, it's help me..

thanks a lot....

 

[alansidman]

If you wish to know if the apostrophe is in the cell as a preceding character, you could test using the following assuming your value is in A1

=ISTEXT(A1)