Merging Book Lists That Are In Different Formats

[andypix46]

Hi, I have been given a lot of free books for my Ereader but the inde
is in 2 different formats.

The first list is in this format:-

Book_Title - Author.Mobi

and the second is :-

Surname, Christian name - Title.Mobi

I'm running Excel 2010 but my knowledge is limited so please be gentle.

Is there any way I can combine these lists and check for duplications o
even just split the list e.g. separate the Title from the author?

All help greatly appreciated, many thanks
And

 

[andypix46]

Hi Andy,
Have a look in the help function for details on "text to columns". Thi
should make what you're trying to do a doddle.

Failing that, attach the lists and i'll help from there.

S.

Thanks for that, it was quite eas