Want to add another seperator to a row of unique values

[Bazoeki]

From a look up field a have a row of values which are in my case dog breed subscriptions. I cropt this row by using the Array unique functions so it only shows unique vallues. Some rows have just one unique value of some have for example 3. I want to seperate always the last value in a row with an & or and instead of a comma.

For example

Bernese Mountain Dog, Rhodesian Ridgeback, Labradoodle → Bernese Mountain Dog, Rhodesian Ridgeback & Labradoodle

Rhodesian Ridgeback, Labradoodle → Rhodesian Ridgeback & Labradoodle

Does anyone now a solution for this problem?

[ScottWorld]

This post may help you:

Adding an Oxford Comma to a List Show and tell

I’m working on an amateur project that involves outputting nice-looking text. I managed to cobble together something that serves my specific needs and thought I’d share it here in case it helped anyone else (and also so I can save the link for reference later). Many thanks go to @W_Vann_Hall for the sample base demonstrating how to extract the last name from a field, which was a crucial piece in my “finding the last comma” puzzle. Is there a PROPER name formula in Airtable? - #3 by W_Vann_Hall …

[Alexey_Gusev]

Hi,

SUBSTITUTE( field ,’,’,’ &’,LEN(field
)-LEN(SUBSTITUTE( field ,’,’,’’)))