Excel CSV change delimiter and date format
Опубликовано: 13 Октябрь 2024
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
5,655
13
00:00 Create a CSV where File Save As CSV is not working
00:18 Create the CSV in Excel using formula with specific delimiter
00:41 How Excel must handle blank cells in the CSV
01:20 Copy Paste Formula straight into text file
01:35 CSV date format problems
02:00 Formula to create the CSV date in the exact format required
If you cannot use the built in Save As CSV option in Excel due to problems with the delimiter or date formats, this is a way to create the CSV from Excel with your own delimiter selection and date/ text formats you require.
