Help! I need to delete data in cells but not all the data.
For example: In one cell I have 10.00% (12.00%) directly underneath. I want to keep the 10.00% but delete the (12.00%). Not all the data is the same, some may be 100% (85%) others could be 4.00% (3.75%) the numbers vary. But everything I do want deleted is a percentage in parenthesis. Is there a way I can do this?
Thank you!
Bookmarks