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....editreplace

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"
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" 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? :)