Excel has a built in function to do that for you.
Paste the data a in the spreadsheet so it is all in coulmn a.


Code: 
Babar and Father Christmas [1985][DVDRp] - http://username:password@www.fileserve.com/file/hhhhhhhh
To move all data following the minus/hyphen sign ( - ).

Hit the column A button to highlight all the data in that column.

Click "Data" in the top menu then select "Text To Columns".
On the Text To Columns window, select "Delimited" and then hit "Next".
In the following window, choose "other" for type of delimiter and use the minus/hyphen sign ( - )

Now hit Finish. You will now have 2 columns.
Lock Down Reviewed by Lock Down on . A kind of help need for Ms Excel usage Babar and Father Christmas - http://username:password@www.fileserve.com/file/hhhhhhhh I want to do seperate these 2 part in excel, left section is name and right section is url what kind of action can seperate this one when I put it , it put all txt in 1st colum not seperate in 2 columns for example I will put a filter to seperate after ] - Rating: 5