How To Use Function To Reduce Characters In Excel. Now you can see the list of characters in excel; It takes care of extra spaces caused by empty cells.

Press ctrl + h to open the find and replace dialog. Copy range and paste in range a2:a255; Using the substitute function to remove characters