MLA to Bookseller Marketplace Formula

[Alba_Machado2]

Hustling bookseller back with another puzzler. What formula would I use to take data in my dad’s {Publisher MLA} field (NY: Atheneum, 1979) and separate it out into three formula fields ({PublishPlace}, {Publisher}, and {PublishYear})? Bonus for a formula that can change NY to New York too. Please and thank you. :slightly_smiling_face:

[Alba_Machado2]

I don’t know where to click Solution because it’s kind of all over the place in this exchange :joy:

[Kamille_Parks]

Dealer’s choice. Every formula we gave you works, so any reply with a formula in it is the solution. I recommend either the very first formula given or the very last one (the reply which describes {Place} and {Year}).