Formula to Remove Space blanks at the end of a cell

[Abdullah995]

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

 

[AliGW]

In C2 copied down:

=SUBSTITUTE(TRIM(B2),CHAR(10),"")

 

[ETAF]

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

 

[AlanSidman]

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.

 

[AliGW]

TRIM won't remove the carriage return. That's what's causing the mismatches.