Excel 2002: How to eliminate varying spacings betwen text?
 

Dear Sir,

I wish to eliminate different number of spacing between text, may II know
what formula must I key in at cell B1 and copy down to get the answer ?


A B
1 HGT 2645 HGT2645
2 B2T 2147 B2T2147
3 V2 2657 V22657
4 N6L 2478 N6L2478
5 KP9 8746 KP98746


Thanks

Low




--
A36B58K641

Excel 2002: How to eliminate varying spacings betwen text?
 

Do a find and replace. For "Find what" use a space, for Replace just
leave it blank.

Mr. Low wrote:

Dear Sir,

I wish to eliminate different number of spacing between text, may II know
what formula must I key in at cell B1 and copy down to get the answer ?


A B
1 HGT 2645 HGT2645
2 B2T 2147 B2T2147
3 V2 2657 V22657
4 N6L 2478 N6L2478
5 KP9 8746 KP98746


Thanks

Low

Excel 2002: How to eliminate varying spacings betwen text?
 

Hello Bob,

Thanks for your tip.

It works perfectly well.

Best Regards

Low

--
A36B58K641


"Bob I" wrote:

Do a find and replace. For "Find what" use a space, for Replace just
leave it blank.

Mr. Low wrote:

Dear Sir,

I wish to eliminate different number of spacing between text, may II know
what formula must I key in at cell B1 and copy down to get the answer ?


A B
1 HGT 2645 HGT2645
2 B2T 2147 B2T2147
3 V2 2657 V22657
4 N6L 2478 N6L2478
5 KP9 8746 KP98746


Thanks

Low

Excel 2002: How to eliminate varying spacings betwen text?
 

You are welcome, have a great day!

Mr. Low wrote:

Hello Bob,

Thanks for your tip.

It works perfectly well.

Best Regards

Low