Use Excel's AI to split your text into columns
Опубликовано: 13 Октябрь 2024
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
1,041
3
00:00 Using Flash Fill to split text into columns
00:13 Steps to make Flash Fill work (fixed width)
00:35 Flash fill short = CTRL +E
00:40 Keep leading zeros with Flash Fill
01:04 Flash Fill with delimiter
01:36 Flash fill for large numbers with leading zeros
Use Excel's built in Artificial Intelligence to take text and split it into columns by identifying the pattern it can see based on examples you give it.
