Hello,
The data spreadsheet I am working with is really messed up and there are SEVERAL entries in one cell with mixed text, numbers, and spaces. In just ONE cell there is:
Example 1
2006: Agri-Appraisal Co (200.00), Chamblin, Jack (200.00), Crocker, Robert (200.00), Jones, Jr., Donald (1,000.00)
Example 2
(1998) George Genseal $200; Mary J. Stambaugh $250; Al E. Stock $250 (1998) Non-Itemized $3,349
I want to extract the dollar amounts. In example 1, I want the numbers in parenthesis. In example 2, i want the numbers with the dollar signs. I am most comfortable with equations but I am open to other options.
Thank you in advance
Bookmarks