Personally I'd do both. Anytime I'm going to sort I will always add a
unique field no matter what. Been there too many times when I've not done
it and then regretted it (Have to close without saving and lose what you've
done to get back). I'll use Domenic's method for the blanks, but SORT =
UNIQUE ID every time.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Bill Ridgeway" wrote in message
...
Peo,

Thanks for that. This is better than my suggestion for Rebecca for
filling
in blanks.

Regards.

Bill Ridgeway
Computer Solutions

"Peo Sjoblom" wrote in message
...
Sure

"Try the following...

1) Select/highlight your data (five columns)

2) Edit Go To Special Blanks Ok

3) Enter your unique character

4) Press CONTROL+ENTER


--
Regards,

Peo Sjoblom


"Bill Ridgeway" wrote in message
...
Peo,

I don't have Domenic's solution (not received or deleted in error)
could
you please re-post it?

Thanks.

Regards.

Bill Ridgeway
Computer Solutions