shanenicholson88
New Member
- Joined
- Oct 6, 2020
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
Good morning all,
I am really struggling to solve this issue, any solutions are most welcome.
I need to create a macro to get the numbers from a string in cells a1:a200 and put just the numeric value in b2:b200. I am using excel 2010 and do not have the GetNumeric function available.
I simply need it look like this after the marco has ran..
Column A Column B
EJU11 11
EZY22 22
Thank you so much for your help.
I am really struggling to solve this issue, any solutions are most welcome.
I need to create a macro to get the numbers from a string in cells a1:a200 and put just the numeric value in b2:b200. I am using excel 2010 and do not have the GetNumeric function available.
I simply need it look like this after the marco has ran..
Column A Column B
EJU11 11
EZY22 22
Thank you so much for your help.