I’ve just imported my library database from librarything.

Copy and paste worked as a charm for my 711 books, I was impressed!

The only thing is that on the Author field I got “surname, name” records: “Kafka, Franz”

When I try to link them to another record in a new base, I get one record for “Franz” and another for “Kafka”.

Is there a formula to join text separated by comma within a record?