how can i remove space in start of value by using formula ( 222) into (111) ( ) assuming cell.
C capreecorn Mar 18, 2009 #1 how can i remove space in start of value by using formula ( 222) into (111) ( ) assuming cell.
J Jacob Skaria Mar 18, 2009 #2 Suppose A1 = " 123" In B1 use the formula '=Trim(A1)' will change that to "123" If this post helps click Yes
Suppose A1 = " 123" In B1 use the formula '=Trim(A1)' will change that to "123" If this post helps click Yes
