1)Edit one of the cells [F2]
2)Select the one blank character
3)Copy that character [Ctrl]+C
4)Select the range of "numbers"
5)EditReplace
-Replace what: Paste the character [Ctrl]+V
-Replace with: delete anything that might be there
-Click [Replace All]
That usually works for me.
--
Regards,
Ron
|