Remove Asterisks (*) from Excel Cells : Data Cleanup Trick!
How to Remove Asterisks (*) from Data in Excel – Easy & Step-by-Step Tutorial!
Is your Excel sheet filled with annoying asterisks (*) that ruin your formulas, sorting, or formatting? Don’t worry—this video is your complete guide to removing asterisks in Excel using simple and effective methods.
🔍 In this step-by-step tutorial, you’ll learn:
✔️ Why asterisks can mess up your Excel calculations and visuals
✔️ How to use the SUBSTITUTE function to remove asterisks from any position—start, middle, or end of a cell
✔️ A powerful Find & Replace trick using ~* to instantly clean large datasets
✔️ BONUS: Remove multiple special characters using nested SUBSTITUTE formulas
💡 Whether your Excel data came from websites, external databases, or messy imports, cleaning up special characters like * is essential for a professional-looking and functional spreadsheet.
📌 Excel Formula Used:
=SUBSTITUTE(A2, "*", "")
📌 Bonus Formula (Remove multiple symbols):
=SUBSTITUTE(SUBSTITUTE(A2, "*", ""), "#", "")
🎯 This video is perfect for anyone searching:
how to remove asterisk in Excel
clean special characters in Excel
SUBSTITUTE function Excel example
Excel find and replace special characters
Excel data cleanup tutorial
✅ Don’t forget to LIKE this video if it helped you, and SUBSCRIBE to Easy Click Learning for more time-saving Excel tips & tricks!
📥 Got a question or another Excel issue you want solved? Drop it in the comments—I’m here to help!
#ExcelTips #RemoveAsterisksInExcel #ExcelCleanup #ExcelFormula #SUBSTITUTEFunction #EasyClickLearning #ExcelDataCleaning #ExcelTutorial #FindAndReplaceExcel
Related Videos:
• Copy Excel Worksheets Like a PRO – Top 3 S...
• Excel 401(k) Calculator: Plan Your Retirem...
• Sync Excel & Google Sheets Automatically U...
🔗 Connect with me:
Facebook: https://www.facebook.com/profile.php?...
X: https://x.com/JB5453