Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula to join text separated by comma within a record?

Topic Labels: Formulas
2222 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Werner_Plaas
4 - Data Explorer
4 - Data Explorer

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
SimonClavey
4 - Data Explorer
4 - Data Explorer

CONCATENATE({Last Name}, ", ", {First Name})