Excel 2002: How to eliminate empty spaces ?

[Guest]

Dear Sir,

I have some text in column A with spaces (one or more spaces) and some
without.

I would like to make them all uniform without any spaces.

A B
1 ML 12 ML12
2 ML14 ML14
3 KL 15 KL15
4 HG 1234 HG1234
5 BV412 BV412
6 BG 54 BG54
7 BC 2247 BC2247
8 LP4416 LP4416

May I know what formula must I input at cell B1 and copy downward to get the
straight answer ?

I try using =SUBSTITUTE(A1,â€-“,â€â€) but I get back the same thing.

Please help.


Thanks

Low

 

[Guest]

get rid of the dash
=SUBSTITUTE(A1,†“,â€â€)
if this does not work, there is a chance it is something other that a
simple space such as a non breaking space
you could copy column A to column B
select column B
in one of the phrases which did not work copy the space
got to edit find replace
paste the space into find and leave the replace empty
select repace all