Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

=IF(LEFT(A1,1)= ,SUBSTITUTE(A1, ,,1), A1)

Input the formula: =IF(LEFT(A1,1)=" ",SUBSTITUTE(A1," ","",1), A1)