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: Use the TRIM formula. TRIM removes all the spaces except single spaces between words. It’s very easy to use: =TRIM (A1) removes all the spaces of cell A1 (as said, single space characters between words stay). Please note: 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.