Kako sortirati razbacane rapidshare linkove

[Mihajlo]

Ako vam se desi da imate rapidshare fajlove koji nisu postavljeni po redu,i zelite da ih sortirate,evo sta treba da uradite.

1.Ako imate ovako razbacane linkove

http://rapidshare.com/files/264041523/yakkys_doodle_22_-_foxy_friends__fester1500_.avi
http://rapidshare.com/files/264041526/yakkys_doodle_06_-_railroaded_duck__fester1500_.avi
http://rapidshare.com/files/264041551/yakkys_doodle_29_-_witch_duck-ter__fester1500_.avi
http://rapidshare.com/files/264041861/yakkys_doodle_15_-_ha-choo_to_you__fester1500_.avi
http://rapidshare.com/files/264041907/yakkys_doodle_31_-_baddie_buddies__fester1500_.avi
http://rapidshare.com/files/264042193/yakkys_doodle_23_-_mad_mix_up__fester1500_.avi
http://rapidshare.com/files/264042225/yakkys_doodle_08_-_whistle-stop_and_go__fester1500_.avi
http://rapidshare.com/files/264042228/yakkys_doodle_10_-_school_fool__fester1500_.avi
http://rapidshare.com/files/264042231/yakkys_doodle_02_-_hop__duck_and_listen__fester1500_.avi
http://rapidshare.com/files/264042274/yakkys_doodle_01_-_out_of_luck_duck__fester1500_.avi
http://rapidshare.com/files/264042634/yakkys_doodle_05_-_foxy_duck__fester1500_.avi
http://rapidshare.com/files/264042643/yakkys_doodle_18_-_shrunken_headache__fester1500_.avi
http://rapidshare.com/files/264042690/yakkys_doodle_16_-_foxy_proxy__dummy_.avi
http://rapidshare.com/files/264042708/yakkys_doodle_17_-_count_to_tenant__fester1500_.avi
http://rapidshare.com/files/264042756/yakkys_doodle_28_-_dog_pounded__fester1500_.avi
http://rapidshare.com/files/264042758/yakkys_doodle_07_-_duck_hunting__dummy_.avi
http://rapidshare.com/files/264043084/yakkys_doodle_24_-_beach_brawl__fester1500_.avi
http://rapidshare.com/files/264043105/yakkys_doodle_04_-_easter_duck__dummy_.avi
http://rapidshare.com/files/264043159/yakkys_doodle_03_-_dog_flight__fester1500_.avi
http://rapidshare.com/files/264043237/yakkys_doodle_27_-_nobody_home_duck__fester1500_.avi
http://rapidshare.com/files/264043239/yakkys_doodle_32_-_judo_ex-expert__fester1500_.avi
http://rapidshare.com/files/264043557/yakkys_doodle_13_-_happy_birthdaze__fester1500_.avi
http://rapidshare.com/files/264043575/yakkys_doodle_14_-_horse_collared__fester1500_.avi
http://rapidshare.com/files/264043593/yakkys_doodle_26_-_hasty_tasty__fester1500_.avi
http://rapidshare.com/files/264043677/yakkys_doodle_19_-_the_most_ghost__fester1500_.avi
http://rapidshare.com/files/264043704/yakkys_doodle_12_-_it_s_a_duck_s_life__fester1500_.avi
http://rapidshare.com/files/264043809/yakkys_doodle_21_-_all_s_well_that_eats_well__fester1500_.avi
http://rapidshare.com/files/264043893/yakkys_doodle_11_-_oh_duckter__fester1500_.avi
http://rapidshare.com/files/264043933/yakkys_doodle_30_-_full_course_meal__fester1500_.avi
http://rapidshare.com/files/264043956/yakkys_doodle_20_-_stamp_scamp__fester1500_.avi
http://rapidshare.com/files/264044222/yakkys_doodle_09_-_duck_the_music__fester1500_.avi

mozete veoma lako da ih sortirate.Glavni problem sto ne moze da se sortira jednostavnim klikom u MS Word-u je zbog ovih brojeva (264043933,264044222...).

2.Kopirajte sve linkove u MS Excel u kolonu A1.



3.Oznacite kolonu A1



4.Idite na "Data",pa "Text to Columns..."

5.Kliknite "Fixed width",zatim "Next >"

6.Kliknite na dio poslije brojeva "264041523/"odmah ispred slova.



Kliknite "Finish".

7.Sada ste dobili dvije kolone.Oznacite drugu kolonu (kolona B) i idite na "Data",pa "Sort".Tu idite na "Sort by:Column B" i oznacite "Ascending". Kliknite Ok.

8.U prvom redu trece kolone (C1) napisite "=CONCATENATE(A1;B1)" bez navodnika.Oznacite C1 i kliknite dva puta u desni donji ugao.



9.Dobicete ispravne,sortirane linkove.Tutorial gotov,uzivajte.​