Below is a data in cell a2. in cell K2 in need to extract the city, in L2, i need the State, and M2 the zip code. These values will change, so the only permamanet text is "Known as:" and "Borrower" so the city will be between both commas all the time, then the state then zip code.
Situated in the City of xxxx, County of xxx and State of xx, and known as being all of Lot 15 in the blah blah foundation, as recorded in Plat Book xx, Pages xx, xx, found County Records of Plats, be the same more or less, but subject to all legal highways. Permanent Parcel No. xx-xxxxx1 Known as: 155 Goodhue Dr., Akron, Ohio 44313 Borrower understands and agrees that xxxx, LLC holds only legal title to the interests granted by Borrower in this mortgage, but, if necessary to comply with law or custom, xxxx, LLC (as