Wow, I seem to be so close. I don't understand why the formula won't carry
down the column without an error.

I also do not know how to replace space with nothing. What am I typing for
"FInd what" and "Replace with"?

"Ken Wright" wrote:

> 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?
> >
>
>
>