M
Mr. Low
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
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