I would like to have a formula column in a table where I have a code name as the first column today. This formula should check the code and give me a determinated result.
Today my codes are SFPAPXXXXRI004, or SFPAPXXXXBA005. I would like a column that says “Ring” if there is an “RI” on the code or “Bracelet” when there is a “BA” and so on.
Is this possible.
Many thanks for your help!