Find and Replace function in Excel may solve this problem, please do as follows:
1. Select the cells that you want to remove the HTML tags.
2. Hold Ctrl + H keys to open the Find and Replace dialog box, in the dialog, in the Find what text box, type <*>, and leave the Replace with text box blank
3. Then click Replace All button, all the HTML tags are removed at once.