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