Help About Excel

[shehzad_umar]

457423896|Dell Photo Printer 540 Duracell Universal 90W Ultra Slim Auto/Air Adapter|12109|BatteryFuel.com|http://www.shareasale.com/m-pr.cfm?merchantID=12109&userID=YOURUSERID&productI D=457423896|http://www.batteryseller.com/images/AA-6001.gif|http://www.batteryseller.com/images/AA-6001.gif|69.49|89.99|Computer|Hardware| Product Details:<br>This is the Duracell Universal 90W Ultra Slim Auto/Air Adapter ( Duracell Universal 90W Ultra Slim Auto/Air Adapter ) for the Dell Photo Printer 540 . <br />|Printer|Dell|Photo Printer 540|-|Black|2007-08-24 19:36:59.493|instock|Battery-Biz Inc.|AA-6001|Printer|Auto/Air Adapter|Dell Photo Printer 540 Duracell Universal 90W Ultra Slim Auto/Air Adapter ( Duracell Universal 90W Ultra Slim Auto/Air Adapter ) ||

is data ko agar hum Excel mein paste karain tou yeh aik hi cell mein paste
ho jata hai mujhe har pipe sign "|"ke baad wala text alag cell mein save karna hai. Please help me.

[D@y W@lk3r]

Re: Help About Excel

app ka q main nahi samjha app kiya chah rahay hain....... app screen shot day. may i help u......... Excel ka expert to nahi hoon. but have a lot of knowledge........

[shehzad_umar]

Re: Help About Excel

app"]W@lk3r;553206]app[/email] ka q main nahi samjha app kiya chah rahay hain....... app screen shot day. may i help u......... Excel ka expert to nahi hoon. but have a lot of knowledge........

Sab se pehlay top par jo paragraph hai usko copy karke notepad mein paste
karain phir notepad se copy karke Excel mein paste karain yeh data aik hee
cell mein paste ho jai ga. Meine sara data cell A2 mein paste kiya hai.
See PIC # 1


Mujhe iis tarah karna hai.
Cell No A2 Mein "457423896"
Cell No B2 Mein "Dell Photo Printer 540 Duracell Universal 90W Ultra Slim Auto/Air Adapter"
Cell No C3 Mein "12109"

I realize that now u have understand my question.
See PIC # 2 and Pic # 3

[shehzad_umar]

Re: Help About Excel

Pic No 1

[shehzad_umar]

Re: Help About Excel

Pic No 2

[shehzad_umar]

Re: Help About Excel

Pic No 3

[D@y W@lk3r]

Re: Help About Excel

to dear manuel hi past kardo two mints hi to lagay gay. aisa nahi hota kay app aik text copy karay aur aik cell main past karay aur wo baki sab main takseem ho jay... yah to app ko manuell hi karna paray ga...........

[shehzad_umar]

Re: Help About Excel

to dear manuel hi past kardo two mints hi to lagay gay. aisa nahi hota kay app aik text copy karay aur aik cell main past karay aur wo baki sab main takseem ho jay... yah to app ko manuell hi karna paray ga...........

Bhai jaan manually to karloon lekin yeh at least 5000 lines hain meray paas
to manually paste karnay mein aik saal laga jai ga koi formula nahi lag sakta.

[Madiha naz]

Re: Help About Excel

Dear mere khayal me ye possible nahi ke kisi formula k zariye aap apne data ko apni marzi k cell me divide ker sako. ye to manually hi possible he.