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: [ Ссылка ]

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: [ Ссылка ]

свернуть