Does anyone know a formula I can use to bring back any words in quotation marks in a cell? For example, my cell contains the following text:
HANSEN 7 ASSET DESCRIPTION COMMENTS: SEAT - ENGLISH HARDWOOD WITH PROTECTIONAL PAINT, LOCATED IN UG-GEO-FRIENDSHIP LAWN. PLAQUE ATTACHED TO SEAT "DONATED FOR JOHANNES THEODORUS DONS".
I want to do a formula that says IF the cell contains quotation marks, bring back the information between those quotation marks, therefore I should end up with DONATED FOR JOHANNES THEODORUS DONS. If easier then a formula that says IF the cell contains "Plaque", bring back the words contained in between the quotation marks......
Thanks
Emma
Bookmarks