Clearing cell contents that meet certain criteria for a very large selection

Hi all. I have a spreadsheet containing a huge number of cells with the logical value "". I'm using the following code to convert them to blank cells:

Please Login or Register  to view this content.

It's taking forever to complete even the first column of data let alone going all the way out to BBT!

Can anyone suggest a more efficient code or an amendment to what I've already got?

Many thanks,

Darren

Thanks, Jeff.

I found the TRIMALL code still took too long but the alternative provided was suitable (given that the cells being trimmed were either a numeric value or ""). The whole process took about 15 minutes and has reduced the size of my file by about 80%!

I've really appreciated your help.

Darren