Hello,
My ActiveCell holds a string which always is made up of two parts:
First part is made up of alphanumerical values.
Second part is made up only by alphabetical values.
Example1:
01a 2 00 Shhkjk yiiy jgjgjg
Or
Example2:
012.00 Shhkjooo k yiiy jgjgjg
I need a VBA code which could return the length of the alphanumerical part (first part), which would be 8 in Example1 and 6 in Example2.
Could you please advice?
Thank you
Bookmarks