Very Urgent Help All Members

[Mubashir Aziz]

Aab aap ghair zaroori rows ko delete kar dain aur aap kay pass neechay di gai rows aa jain gi

18-May-09 03:33 PM 3,803 7g.jpg
22-Jun-09 02:29 PM 0 a.txt
06-Oct-06 12:21 PM 19,152 aviator.gif
03-May-06 02:58 PM 126,146 fire_avator1.gif
16-Jun-09 02:53 PM 8,209 flag1.gif
16-Jun-09 02:53 PM 3,131 flag10.jpg
16-Jun-09 02:35 PM 11,296 lione.gif
18-May-09 03:37 PM 1,313 mubashiraziz.jpg
18-May-09 03:36 PM 3,439 mubashir_aziz.jpg
19-Jun-09 12:20 PM 6,517 mubashir_aziz80.jpg
10-Jun-09 02:37 PM 16,782 mubashir_aziz_.jpg
16-Jun-09 02:53 PM 16,572 pakistani-flag.gif
16-Jun-09 02:56 PM 7,273 PDT_41.gif
16-Jun-09 02:55 PM 5,821 PDT_42.gif
18-May-09 03:35 PM 3,303 thumb_avatar_(28).jpg
03-Apr-09 01:12 PM 837 wolf.gif


aab aap iss data ko copy kar kay Sheet2 main ja kar paste kar dain .... yaa phir aap sheet1 main he rahtay hoye ghair zaroori rows ko delete kar dain aur B1 main yah formula likh dain ....

=TRIM(RIGHT(TRIM(A1),LEN(TRIM(A1))-FIND(" ",TRIM(A1),20)))

aap kay pass file names aa jain gay ...... main nay yah formula apnay tour par check kar lia hay agar aap ko koi problem ho to excel sheet main data copy kar kay upload kar dain InshaAllah i'll try to solve your file .....

aap ka solve howa kah naheen lazmi bataiye ga ...

[Mubashir Aziz]

Oh sorry yaar actually mujhay DOS use kiye hoye aik arsa ho gia tha aur main Excel main har waqat kam karta raha tha jiss key wajah say main intahi aasan command bhol gia tha ..... aap apny folder par ja kar DOS main yah command likhain to aap ko sirf file names mil jain gay jissay aap excel main copy kar saktay hain ........

C:\Documents and Settings\maziz\Desktop\Avatar>DIR /b >A.TXT

Aab aap windows explorer main ja kar a.txt file ko open karain gay to sirf file names aap ko mil jain gay ......

7g.jpg
a.txt
aviator.gif
fire_avator1.gif
flag1.gif
flag10.jpg
h
lione.gif
mubashiraziz.jpg
mubashir_aziz.jpg
mubashir_aziz80.jpg
mubashir_aziz_.jpg
pakistani-flag.gif
PDT_41.gif
PDT_42.gif
thumb_avatar_(28).jpg
wolf.gif

Sorry ooper wali exercise say aap loog confuse ho saktay hain leekan at least aap ko excel key powerfull commands ko pata lag jai ga ......

[kamibest]

Dear Sir

Pehle Te Mai Ab Ka Bohat Thanks Karna Chaho Ga
Ke Apne Bare Ache Tareke Se Bataya

But

Friend


Maine Doctor Sb Is Ka Software leliye hai

Once Again Thanks