You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.

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. Alternatively, click "Find ...

When the relationship between the charted entities is less important than the individual entities, try using these two chart techniques to highlight important details in Microsoft Excel.