Hi,

You could try replacing the blanks with a space by clicking Crtl + H
then leave go straight to replace with. Click in cell and press the
space bar once.
Then sort Ascending order


VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561267