Launch Excel. Open the worksheet containing the excess Tab symbols that you want to remove. Open the "Find and Replace" dialog box by pressing "Ctrl-H" on your keyboard.

To find and replace specific formatting, open the Find and Replace dialog box (Ctrl + H for Windows, Cmd + H for macOS) and click on “ More >> “. Then, select the “ Format ” button at the ...