Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.
Remove special characters from text string in Excel - Excel Tips and Tricks
4 Views • Jan 05, 2026
Description
These are the formulas outlined in the video.
Prep Column - Get Numeric Value ONLY
=VALUE(CONCAT(IFERROR(MID(A2,SEQUENCE(LEN(A2)),1)+0,"")))
Count Number Of Occurrence
=COUNTIF($B$2:$B$17,D2)
More from User
DELETE rows in Excel without affecting other rows - Excel Tips and Tricks
ExcelTips247
I Created a UNIQUE() Function For Excel 2016 and Older Versions - Excel Tips and Tricks
ExcelTips247
Compare Two Tables In Excel - Excel Tips and Tricks
ExcelTips247
TOCOL and TOROW Functions in Excel - Excel Tips and Tricks
ExcelTips247
I Created a XLOOKUP() Function For Excel 2016 and Older Versions - Excel Tips and Tricks
ExcelTips247
Why Use VLOOKUP() with MATCH() in Excel - Excel Tips and Tricks
ExcelTips247
Related Videos
Remove Special Characters From Text String Using REDUCE - Excel Tips and Tricks
ExcelTips247
How to Remove Non-Printable Characters in Excel - Excel Tips and Tricks
ExcelTips247
How to use Excel to delete, replace and remove special text characters and phrases
HotHotSoftware1
Formula to ignore letters/special characters in cells and only put numbers - Excel Tips and Tricks
ExcelTips247
Count and Search for Text in Excel with Countif - The Ultimate Test of Excel Skills! - Excel Tips and Tricks
ExcelTips247
Remove asterisks in Excel - Excel Tips and Tricks
ExcelTips247