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