Find position of designated character in Cell

A1="&&&a%A689H&" , Based on A1,
B1 – get position of the first lower case letter, in example, to be 4
B2 – get position of the first Upper case letter, in example, to be 6
B3 – get position of the first “number” , in example, to be 7
B4 – get the total QTY of upper case letter,in example, to be 2

thanks,

Hi,

I created a series of User Defined Functions:

Please Login or Register  to view this content.

If this helps please click on Add Reputation below,