Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and paste versus copy and insert copied cells | New Users to Excel | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel |