TRIM?

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?

I can't duplicate your error. You should have been able to copy it down
without any problem if it worked for the first entry. Another function that
can be used is CLEAN in place of TRIM in the formula. See if that makes any
difference.

"Cthulhu" wrote:

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

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

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

You don't need any formulas with the instructions I gave you

When you get the Find/Replace box up, put the cursor in the Find What bit
and hit the space bar once. Leave the Replace with empty and hit OK.

--
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:79537989-BA30-41D9-8697-277B56D6A80E@microsoft.com...
> 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?
> > >
> >
> >
> >

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