Excel Trim remove spaces not working then use TRIM(SUBSTITUTE(C1,CHAR(160),CHAR(32)))

Step1: Formula: =TRIM(SUBSTITUTE(C1,CHAR(160),CHAR(32)))

C1 is the value

Step2: Copy all the column, replace with value.

Step3: convert text to number.