Convert Text to Date | DATEVALUE Function | Text to Columns | Power Query ... and more
Автор: Chester Tugwell
Загружено: 2021-10-19
Просмотров: 5700
Описание:
👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted...
Thank you! 👍👍
Download the featured file here: https://www.bluepecantraining.com/wp-...
In this video I describe how to convert text values into date values. The eight methods I explore are listed below:
Table of Contents:
00:00 - Intro
00:22 - Use the DATEVALUE and VALUE functions
02:26 - Use mathematical operators
03:42 - Add zero using paste special
04:11 - Find and replace custom delimiters
04:50 - Use the SUBSTITUTE function to replace custom delimiters
05:23 - Use Text to Columns
05:50 - Use text functions (advanced method)
09:49 - Use Power Query (adv method)
------------------------
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
