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/

Please take the opportunity to connect and share this video with your friends and family if you find it useful.