Split text into columns
I'd like to split text into separate columns.
The text (found in one cell) has the following form: company name-document type-yymmdd-version number
E.g. I'd like to split Architecture-Proposal-221129-001 into four columns:
- Company Name
- Document Type
Appreciate any help or advice.
Help Article Resources
Check out the Formula Handbook template!