Is there a formula that can be used to extract data that is in parenthesis in a field? I can use the =Left but the data is not always in the same position in each field in the worksheet. On the attached file I have given four examples of what might appear in my spreadsheet. I only need the 4 digits within the () in Column A to show in Column B.
8.9 KB Views: 4