Clean and Extract Text the EASY Way - Pro Tip!

Описание к видео Clean and Extract Text the EASY Way - Pro Tip!

With Power Query we can quickly and easily extract text strings, whether it's letters, either upper or lower case, or numbers, and even special characters. Download the sample Excel file here: https://bit.ly/3okDqDa

0:16 Introduction
0:42 Text.Select Lower Case Letters
1:28 Text.Select Upper Case Letters
1:48 Text.Select Numbers
2:12 Text.Select Letters and Numbers
2:52 Text.Remove Lower Case Letters
3:42 Text.Remove Upper Case Letters
3:51 Text.Remove Numbers
4:06 Text.Remove Letters and Numbers
4:28 Text.Remove Special Characters
5:35 Unicode Trick

View our comprehensive courses: https://www.myonlinetraininghub.com/

Комментарии

Информация по комментариям в разработке

Похожие видео