Рет қаралды 13,403
Power Query Training / M Query: Basics
-How to remove special characters in Excel?
-How to use Text.Select?
Power Query and Power BI uses the same type of data transformation techniques. Clear out special characters from your data entry by defining which characters to keep. Remove special characters without the need of Substitute formulas, no loops in VBA visual basic, simple and easy.
Data transformation and data cleansing using Power Query.
Functions Used:
-Text.Select([ColumnName], {"A".."Z", "a".."z", "0".."9"})
This keeps alphanumeric characters, both uppercase and lowercase letters and numbers
-Text.Select([ColumnName], {"0".."9"})
This keeps numbers only
Beginner Microsoft Excel Tutorial
#powerquery #powerquerytutorials #exceltutorial