Top Navigation

Tuesday 25 August 2020

Remove Spaces from Cell or Remove Unwanted Characters | Excel Useful Formulas

 =TRIM(A1)


=TRIM(CLEAN(A1))

 

=TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," ")))


Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)