Fordraiders
asked on
Extract Number from AlphaNumeric string
excel 2010 vba:
What I need:
str2 is a string variable
falpha is just my holder variable
str2 usually is something like: B2 C3 D34 B21 AC3 DE45 etc...
What I need:
I need a variable just to hold the Numeric part of the str2
The code below with extract the alpha part i need
Thanks
fordraiders
What I need:
str2 is a string variable
falpha is just my holder variable
str2 usually is something like: B2 C3 D34 B21 AC3 DE45 etc...
What I need:
I need a variable just to hold the Numeric part of the str2
The code below with extract the alpha part i need
If IsNumeric(Mid(str2, 2, 1)) Then
falpha = Left(str2, 1)
Else
falpha = Left(str2, 2)
End If
str = falpha
Thanks
fordraiders
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER