Why not go with Domenic's solution, no need for sorting and done in less
than 10 seconds?

--
Regards,

Peo Sjoblom


"Rebecca" wrote in message
...
I forgot to ask, Bill, and I'm kind of embarrassed to do so. How do I add
a
unique reference number to a column? The worksheet is very long.

"Bill Ridgeway" wrote:

I can only guess at the structure of your spread sheet.

First, I would suggest you add a field (column) "Unique reference
number"
(URN) and fill it with a unique number for each record. This will ensure
that, whatever happens, you may be able to re-sort the spreadsheet back
into
its original order.

Secondly sort (each field) which will bring all the blank cells together
so
that you may add "@" en bloc.

Sort the spreadsheet back to its original order and delete the field URN.

Depending on the structure and size of you spreadsheet this may be a bit
laborious but it should make it easier not to miss a cell or two if you
were
to look and change individual cells.

Regards.

Bill Ridgeway
Computer Solutions

"Rebecca" wrote in message
...
Hi. I am using MS Excel 2003, and I am very new to the program, so if
you
can help me, please explain everything in very easy English.

I need to fill many blank (empty) cells that are located in various
places
(there are five columns) throughout a worksheet. I want to fill the
blanks
with an "@" (or some other unique character) so I can later search and
replace to remove them easily (after some sorting). How can this be
done?
And please explain it so a newcomer can understand. Thanks.