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