Text to columns fixed width Excel template (formula based)
Опубликовано: 09 Октябрь 2024
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
1,109
3
00:00 Creating (easy) templates with formulas for fixed width text to columns
00:25 Set up cells to help with the formula (make it easy to copy across, not retype)
00:50 Use LEFT to extract the first fixed width column
01:23 Use MID function to extract the next fixed width column
02:14 Use MID to extract the last fixed width column
How to create a template with reusable formula to separate text to columns where it is driven by fixed width as apposed to delimiter.
