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
--
ve_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" wrote in message
...
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
--
ve_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

try this

=VALUE(TRIM(CLEAN(A1)))


try this you may succeed

=VALUE(TRIM(CLEAN(A1)))





"lovebaby" wrote in message
.. .
For some reason, Trim does not work!
"Kassie" wrote in message
...
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
--
ve_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" wrote in message
. ..
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

"lovebaby" wrote in message
. ..
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