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: Download and try it for free: No sign-up, no installation (just activation within Excel) and a lot of other useful functions. This function is included in our Excel Add-In 'Professor Excel Tools'
Learn more Download Free Trial
(No sign-up, download starts directly)
More than 35,000 users can't be wrong. Method 4: Remove all the spaces – except those between words
There is another option, which is not as exact, but in most cases still possible: 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: