Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula to join text separated by comma within a record?

Topic Labels: Formulas
1447 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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