Help

MLA to Bookseller Marketplace Formula

Topic Labels: Formulas
Solved
Jump to Solution
2472 21
cancel
Showing results for 
Search instead for 
Did you mean: 
Alba_Machado2
7 - App Architect
7 - App Architect

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:

21 Replies 21
Alba_Machado2
7 - App Architect
7 - App Architect

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

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}).