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
Here is a formula solution for you
Formula:
Please Login or Register to view this content.
v A B 1 01a 2 00 Shhkjk yiiy jgjgjg 8 2 012.00 Shhkjooo k yiiy jgjgjg 6 3 125 465 48 POIPONns 10 4 2R 32aa 6547 POD_DDD 12
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi plans,
maybe something like this
Please Login or Register to view this content.
Last edited by nilem; 03-05-2016 at 02:08 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks