A kind of help need for Ms Excel usage

[cenginturk]

Babar and Father Christmas [1985][DVDRp] - http://username:[email protected].../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 ] -

cenginturk Reviewed by cenginturk on 11th May 2011. A kind of help need for Ms Excel usage Babar and Father Christmas - http://username:[email protected]/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

[mannNmeet]

your file not available
but you can use filter for separating anything in excel

Thanks,
Mann

[cenginturk]

I know file is not there, its fake url, but I do not know how to use filter in OFFICE 2010

I just want to make my one click url list and seperate it

Babar and Father Christmas [1985][DVDRp] - http://username:[email protected]/file/hhhhhhhh

[Lock Down]

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.

Babar and Father Christmas [1985][DVDRp] - http://username:[email protected]/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.

[cenginturk]

thanks very very very ..................(million times) muccchhhhh