A formula to return characters between text and the next semicolon in a cell
Column A always contains the information "PLAN 1234;"
- The semicolon is always the third semicolon.
- The plan numbers are alphanumeric and can be any length.
I need to return just the plan number without "PLAN " but not sure what I'm misunderstanding about how to use FIND, LEN, etc. I can get the individual functions to work but not when I combine them.
Help Article Resources
Check out the Formula Handbook template!