How do I remove spaces

[lovebaby]

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

 

[Guest]

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

 

[lovebaby]

For some reason, Trim does not work!

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

 

[R.VENKATARAMAN]

try this

=VALUE(TRIM(CLEAN(A1)))


try this you may succeed

=VALUE(TRIM(CLEAN(A1)))

 

[Bob Phillips]

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)

 

[Don Guillett]

See answers in public and pls don't multipost