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.

MLA to Bookseller Marketplace Formula

Topic Labels: Formulas
Solved
Jump to Solution
8855 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}).