How can I remove the space at the end of the cell value? I am not able to calculate values because of this.



Please find attached the Excel File as an example.

Attached Files

Remove Spaces from the End of Cells.xlsx (10.1 KB, 13 views)

Something like =SUMPRODUCT(--TRIM(CLEAN(SUBSTITUTE(D3:d21,CHAR(160)," ")))+0) for col D ?

(CHAR(160) is the non breaking character space, not the usual space whiich is CHAR(32)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank a lot for your support. It's working quite fine.