Split Text to Columns Using Formula?
If I have a column with text like this:
Using formulas, how can I pull the data that comes before and after the semicolons? I want to end up with 1 column like this:
And another column like this:
Help Article Resources
Check out the Formula Handbook template!