Creating a calculation to separate data from a field
I have a data field with 2 items in it separated by a colon. Example:
I would like to separate item1 from item2 and create a new field for each. I saw many examples of separating first and last names that are in the same field but that is when the data is separated by a space. I can't figure out how to adjust the formula to have the separation be at the ";" i/o a space.
Appreciate any help I can get - thanks!