MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Deleting blank spaces in multiple cells

Posted by Phil on July 02, 2001 12:17 AM

Is there a quick way to delete a blank space at the start of each cell in a large range (ie. 10 columns x 500 rows) so that date and number formatting can be effected.

Posted by Ivan F Moala on July 02, 2001 1:42 AM

If you mean to delete a space in each cells
data eg " 12:00" then just select the data
range THEN click on Edit / Replace
in Findwhat just enter a space then click
Replace All......???


Posted by Phil on July 02, 2001 7:08 PM

Thanks Ivan,
It was so obvious I couldn't see it - your a champ!