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

--
A36B58K641