copy value

[RKS]

hi
client send me one big excel sheet. in column B use custom format with
varius text. when we enter number the value with unit. like

B value display
45 45 pcs
34 34 mtr
45 45 ltr

my problem is there is not same text like pcs, mtr or ltr. its differen when
i use copy thru paste special and select value only number display.

i wants 45 pcs so i can split in 2 column like 45 nd PCS
please help me urgently.

 

[driller2]

your case is same with mine, maybe a genuine macro can solve this...help pls.

 

[Teethless mama]

Copy > Paste it into Note Pad > Copy from Note Pad & Paste it into Excel

 

[Gord Dibben]

Good suggestion and works like a hot d__n


Gord Dibben MS Excel MVP