Occasionally I will have an Excel file that contains HTML markup that I need to remove. The Excel Replace feature makes removing HTML easy. To remove the HTML tags highlight the cells that contain the HTML and then select Edit > Replace. In the “Find what” field enter <*>. Leave the “Replace with” field blank and then click on the “Replace All” button. Poof! All of your HTML will magically be removed.
Like this:
Like Loading...
Author: Bruce Elgort
You’ll find this technology professor – an award-winning instructor at Clark College – working hard to inspire and challenge his students with meaningful web development and programming experiences. With a skinny vanilla latte (no foam) in hand, Bruce loves to tinker and test the boundaries of existing and emerging technologies, to then guide hungry minds through memorable, educational journeys to showcase with passion the ever-evolving innovations of society. An industry leader, Bruce is known for co-developing Elguji’s IdeaJam software, and is recognized by IBM as an ‘IBM Champion’ for being an innovative thought leader in cloud technologies.
View all posts by Bruce Elgort
Bruce Elgort 
Thanks, it worked for me and modified 19286 records in a second.
You have no idea how useful that was for a silly newbie, who would do it by hand instead. Thank you very, very much. Great tip!