Split text after FIRST delimiter only with Excel functions
Опубликовано: 27 Сентябрь 2024
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
4,385
12
00:00 Use a formula to split text into columns by finding the position of the first delimiter
00:42 Extract the account number to the left of the first delimiter
01:06 Extract the account description just after the first delimiter
Use a formula to create a template that will split text to columns based on only the first delimiter.
