MrExcel Publishing
Your One Stop for Excel Tips & Solutions

leading space


Posted by CDWD on September 13, 2001 10:58 AM

how do I remove leading space from all cells in one column?


Posted by Mark W. on September 13, 2001 11:49 AM

Select the column. Next, choose the
Data | Text to Columns... menu command. At
Step 1 of 3 of the wizard select "Fixed width",
and press [ Finish ].

Posted by loren on September 13, 2001 11:50 AM

Posted by cdwd on September 13, 2001 1:26 PM

Thanks!!