How do I remove spaces

I have data as such - (space)number(space)

How do I remove the spaces via a formula or macro?

I have 40,000 entries so I would rather not do it manually.

thanks

Hi

If you have all your entries in one column, use the TRIM function. Let's
say you have your data in Col A, then in Col B enter the formula = TRIM(A1).
That will remove the spaces, but leave your numbers as text, not numbers
--
j.kasselman@atlantic.net.remove_2nd_at. Stilfontein, Northwest, South Africa


"lovebaby" wrote:

> I have data as such - (space)number(space)
>
> How do I remove the spaces via a formula or macro?
>
> I have 40,000 entries so I would rather not do it manually.
>
> thanks
>
>
>
>

For some reason, Trim does not work!
"Kassie" <kassie.kasselman@discussions.microsoft.com> wrote in message
news:921621A3-E279-4389-B067-C72B825C97F5@microsoft.com...
> Hi
>
> If you have all your entries in one column, use the TRIM function. Let's
> say you have your data in Col A, then in Col B enter the formula =
> TRIM(A1).
> That will remove the spaces, but leave your numbers as text, not numbers
> --
> j.kasselman@atlantic.net.remove_2nd_at. Stilfontein, Northwest, South
> Africa
>
>
> "lovebaby" wrote:
>
>> I have data as such - (space)number(space)
>>
>> How do I remove the spaces via a formula or macro?
>>
>> I have 40,000 entries so I would rather not do it manually.
>>
>> thanks
>>
>>
>>
>>

Perhaps they are HTML non-breaking spaces. Try Dave McRitchie's TrimALL,
http://www.mvps.org/dmcritchie/excel/join.htm#trimall


--

HTH

RP
(remove nothere from the email address if mailing direct)


"lovebaby" <mschmidt@carolina.rr.com> wrote in message
news:BGI8f.277$Cw4.51406@twister.southeast.rr.com...
> I have data as such - (space)number(space)
>
> How do I remove the spaces via a formula or macro?
>
> I have 40,000 entries so I would rather not do it manually.
>
> thanks
>
>
>

See answers in public and pls don't multipost

--
Don Guillett
SalesAid Software
donaldb@281.com
"lovebaby" <mschmidt@carolina.rr.com> wrote in message
news:BGI8f.277$Cw4.51406@twister.southeast.rr.com...
> I have data as such - (space)number(space)
>
> How do I remove the spaces via a formula or macro?
>
> I have 40,000 entries so I would rather not do it manually.
>
> thanks
>
>
>

try this

=VALUE(TRIM(CLEAN(A1)))


try this you may succeed

=VALUE(TRIM(CLEAN(A1)))





"lovebaby" <mschmidt@carolina.rr.com> wrote in message
news:3NJ8f.50$0D4.47057@twister.southeast.rr.com...
> For some reason, Trim does not work!
> "Kassie" <kassie.kasselman@discussions.microsoft.com> wrote in message
> news:921621A3-E279-4389-B067-C72B825C97F5@microsoft.com...
> > Hi
> >
> > If you have all your entries in one column, use the TRIM function.
Let's
> > say you have your data in Col A, then in Col B enter the formula =
> > TRIM(A1).
> > That will remove the spaces, but leave your numbers as text, not numbers
> > --
> > j.kasselman@atlantic.net.remove_2nd_at. Stilfontein, Northwest, South
> > Africa
> >
> >
> > "lovebaby" wrote:
> >
> >> I have data as such - (space)number(space)
> >>
> >> How do I remove the spaces via a formula or macro?
> >>
> >> I have 40,000 entries so I would rather not do it manually.
> >>
> >> thanks
> >>
> >>
> >>
> >>
>
>