
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 21, 2020 02:44 PM
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:
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 23, 2020 12:16 PM
I don’t know where to click Solution because it’s kind of all over the place in this exchange :joy:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 23, 2020 12:21 PM
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}
).

- « Previous
- Next »