Validation of partial data in a cell.

C

Chris

I would like to know how I can perform an IF statement on a cell when looking
at just the first few characters in that cell. Any suggestions?

i.e. Cell A1 = "Test"

If(A1={first two characters},1,0)

Thanks in advance, Chris.
 
D

Dave Peterson

=if(left(a1,2)="te",1,0)
or if you're looking to return 0 or 1:
=--(left(a1,2)="te")
the -- stuff changes the true/false to 1/0.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Cumulative formula for word table 0
Found few bugs in my daily routine of work in excel for MAC 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Compile error in table level validation expression in ms access office 2019 0
Found few bugs in my daily routine of work in excel for MAC 0
How to lookup based in the first 3 characters of a cell 2
check first 3 characters of a cell and compare to a table 4

Top