Title: Space Character: Remove Last Letter in Excel If It Is Blank
Headings: Space Character: Remove Last Letter in Excel If It Is Blank
Space Character: Remove Last Letter in Excel If It Is Blank
Method 1: Remove the last letter if it is blank manually
Method 2: Remove the last letter of a cell if it is a space with formulas
So if you want to use the formula, the just copy it from above and replace “B5” with you cell reference.
Method 3: Remove the last space character of a cell faster and easier
This function is included in our Excel Add-In 'Professor Excel Tools'
Method 4: Remove all the spaces – except those between words
By Henrik Schiffner

Content: Spaces in the beginning of the cell will also be removed. Double or triple spaces (and more, of course) between words will be reduced to one single space. If that’s fine for you, the TRIM formula is a nice option. By Henrik Schiffner
Henrik Schiffner is a freelance business consultant and software developer. He lives and works in Hamburg, Germany. Besides being an Excel enthusiast he loves photography and sports. View all of Henrik Schiffner's posts. Post navigation
Previous post
How to Easily Export and Excel Sheet as PDF/XLSX Files: Big Guide! Next post
IF Formula in Excel: