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