I'm not sure about doing the whole shebang automatically, but you can bulk edit books if you want.
If your library is huge, just type in Asimov in the search bar.
Then select all the books you want to change the author. Right click and select "edit meta information" and then "edit meta information in bulk". under "Author(s)" type in what you want and Calibre will change the author for all those books.
|