Excel 2002: How to eliminate empty spaces ?
 

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

Excel 2002: How to eliminate empty spaces ?
 

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


"Mr. Low" wrote:

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