In this video, I’ll show you how to remove special characters from text data in Excel using the new REGEXREPLACE function.
⚡Practice file:
excelkid.com/wp-content/uploa...
⚡More tips:
excelkid.com/
Type REGEXREPLACE and add the first argument, the cell that contains the text. The second argument is the pattern, the regular expression that describes the pattern of text you want to extract. The third argument is an empty string. This means that every part of the original text that matches the pattern will be replaced with nothing.
Chapters:
00:00 Intro
00:06 How to remove special characters from text
#msexcel #excel #exceltips #exceltricks #excelformula #excelfunctions #productivity #datacleaning #datacleansing