• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to Remove Space blanks at the end of a cell

Abdullah995

New Member
How can i remove space blanks from the end of a cell that has names. for example

Cell B12 has no space in it at the end. and Cell B13 has space in the end. I want to remove the spaces at end of a cell. can someone help with formula
 

Attachments

  • Book1.xlsx
    9 KB · Views: 7
non of those examples have a space at the end
The TRIM() function in a new cell , will remove leading and trailing spaces , if you want to clean up a column then likely to need VBA , which i do provide for forums
 
An alternative if you do not wish to use VBA or add a new column to remove the spaces, then bring your table/range to Power Query. Use the Trim function and then close and load back to native excel.
 

Attachments

  • Book1.xlsx
    17.8 KB · Views: 2
Back
Top