
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 03, 2017 10:26 PM
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?
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 14, 2019 01:28 AM
CONCATENATE({Last Name}, ", ", {First Name})
