Split text after FIRST delimiter only with Excel functions
Published: 27 August 2021
on channel: AuditExcel Advanced Excel and Financial Model Training and Consulting
on channel: 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.
Watch video Split text after FIRST delimiter only with Excel functions online without registration, duration hours minute second in high quality. This video was added by user AuditExcel Advanced Excel and Financial Model Training and Consulting 27 August 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,385 once and liked it 12 people.