Select all your data and do Edit / Replace, replacing space with noithing,
as already suggested. Then type a 1 in a cell somewhere, copy the cell,
select all your data and do Edit / Paste Special / values & multiply, or
copy an empty cell and select all and do Edit / Paste Special / values and
Add.

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

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

"Cthulhu" wrote in message
...
Thank you all for your suggestions.

SauveC--

I did try your suggestion combined with Julie's. It worked perfectly for
the first cell. When I tried to drag the fromula down the rest of the
worksheet, however, I get a "#VALUE" error. Now what? :)