@
BookJunkieLI - try this:
Select the books in question (maybe use the Mark Tool and/or tag with say 'TomC'), and then use Edit metadata->Search and Replace in Regex Mode to replace what's there --
(.*) -- with what's there and Tom Clancy --
\1 & Tom Clancy -- viz:
BR