Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

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.

Re: Deleting blank spaces in multiple cells

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......???

Ivan

Re: Deleting blank spaces in multiple cells

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

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

Phil

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.