Create a calculated column using the following formula which will just display the first 3 letters of the reference code – call it something like “First 3 letters”.
=LEFT([TITLE],3)
Then create a view with a filter:
WHERE “First 3 Letters” “Is not equal to” “JHN”
You can use this method to create a view for:
- Does not begin with
- Does not end with (using the RIGHT instead of LEFT function)