What: enter a space using spacebar.

With: do not enter anything

Perhaps TRIM won't work because you have an HTML non-breaking space in the
cell.

To get rid of that....edit>replace

What: hit ALT + 0160 using the numpad

With: do not enter anything


Gord Dibben Excel MVP

On Thu, 10 Feb 2005 10:17:05 -0800, "Cthulhu"
<Cthulhu@discussions.microsoft.com> wrote:

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