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" <Cthulhu@discussions.microsoft.com> wrote in message
news:7C867051-9041-47F8-9CE3-39743B32A3F3@microsoft.com...
> 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?
>