I have an Excel workbook with header cells such as the following:
- birthday 645 (before 1995)
- birthday (after 1995) 99
...
...
I want to remove every number in those cells except for the ones that are needed to be there. In the example above, except for 1995, any other numbers in those cells should be removed.
Is there a way that I can do such a thing? such as defining a function in Python?
Per the comments above, assuming well defined parentheses, you can use this function to remove all numbers that are not nested in parentheses.