So I need help trying to figure this one out.
I can't give too much details as the data is sensative but I have a column with policy numbers for different products they start with 3 letters and end with 9 numbers, the initial 3 letters (for instance "HPT, YTM" etc) are indicators as to the policy type.
So I have the policy number column and then the policy type column, is there a way to auto populate the "policy type" column based on the initial 3 letters in the corresponding "policy number" cell?
Bookmarks