copy value
 

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.

copy value
 

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

"RKS" wrote:

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.

copy value
 

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


"RKS" wrote:

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.

copy value
 

Good suggestion and works like a hot d__n


Gord Dibben MS Excel MVP

On Tue, 20 Oct 2009 07:23:03 -0700, Teethless mama
wrote:

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


"RKS" wrote:

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.