theteacher9999
New Member
- Joined
- Jun 8, 2020
- Messages
- 12
- Office Version
- 365
- 2010
- Platform
- Windows
Hi all,
I'm struggling with this for some time and that's why I'm here.
From the values in column A I'd like to get the result given in the example below. In column B I want to have only the number which is inside the parenthesis in column A. I would like to have an apostrophe before each number.
Do you know how to do it quickly with any formula(s) and/or VBA code?
I'm struggling with this for some time and that's why I'm here.
From the values in column A I'd like to get the result given in the example below. In column B I want to have only the number which is inside the parenthesis in column A. I would like to have an apostrophe before each number.
Do you know how to do it quickly with any formula(s) and/or VBA code?