How to Remove Special Characters from Text Data in Excel - TEXTCLEAN Function

How to Remove Special Characters from Text Data in Excel - TEXTCLEAN Function

In this video, I’ll show you how to remove special characters from text data in Excel using the new TEXTCLEAN function. Using TEXTCLEAN, you can remove special characters - #(*)@ - from a text instead of struggling with LAMBDA-based formulas or PowerQuery. We provide a powerful function that is compatible with ALL Excel versions.

Download DataFX free Excel function library:

Chapters:

0:00 Intro
0:15 How to Remove Special Characters in Excel
0:25 SUMCSV function to sum comma-separated values
0:33 TEXTCLEAN function
1:06 Download DataFX free add-in
1:13 Thank you

#msexcel #excel #exceltips #exceltricks #excelformula #excelfunctions #productivity #datacleaning #datacleansing

[deepamangkali]

Does this formula work in all version of excel, as i cant see on my excel .

[PeckPerk]

Hi there, how could you insert the DataXL into Excel? Thanks!

[lingjuntan]

This function is not in exccel, can you send the link for TEXTCLEAN function please

[ViaAndres-sq]

Is there anyway that can be applicable for date and time with special character on it? I've tried this but it says #NAME? maybe because it is was not a text. Can someone help me huhu

[ScottSchlafman]

where did the green boxes come from and how did you get there ... not so helpful