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.