Remove Special Characters without any formula
Remove Special Characters without any formula or function with the help of Power Query Editor.
This happens when you copy numeric data from email body etc. Many special characters copied from the source.
Simply select the numeric data & convert it into table. Then open it in Power Query Editor.
That's it.
The data is already cleaned and ready. Just Close & Load.
Extract Numbers & Text :- • Extract Numbers & Text from alphanumeric d...
Clean your data with Power Query : • Power Query Data Cleanup.💥✔ #msexcel #powe...
Remove Hidden Objects : • How to remove Hidden Objects in #excel #c...
#powerquery #powerpoint #powerbi
Playlist
• Excel Made Easy
Please subscribe for more interesting videos , kindly go to channel link-
/ casanjeevbansal
/ @casanjivbansal
#excel #excel365
#specialcharactor
#datacleaning #datacleansing #vlookup #xlookup
#casanjivbansal
#casanjeevbansal
#XLProfessionals
#BansalEduTech
My Mic https://amzn.to/2XlXPP2
My Cam https://amzn.to/3z3tt0w
My Laptop https://amzn.to/2VCsSoO