Search This Blog

Monday, December 23, 2019

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.

No comments:

Post a Comment