Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Merging Book Lists That Are In Different Formats
Hi, I have been given a lot of free books for my Ereader but the index 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 or even just split the list e.g. separate the Title from the author? All help greatly appreciated, many thanks Andy |
#2
|
|||
|
|||
Quote:
Have a look in the help function for details on "text to columns". This should make what you're trying to do a doddle. Failing that, attach the lists and i'll help from there. S. |
#3
|
|||
|
|||
Thanks for that, it was quite easy
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging of multiple lists | Excel Worksheet Functions | |||
Merging two lists | Excel Discussion (Misc queries) | |||
merging lists | Excel Discussion (Misc queries) | |||
Merging 2 lists with a twist | Excel Worksheet Functions | |||
Merging data lists - PLEASE HELP!! | Excel Discussion (Misc queries) |