Hi all,
How to search the position of the first alphabet in a alphanemric value.
For eg.
"12345 QRS"
I want the position of the Q , 7
I wrote the Instr function like
pos = Instr("12345 QRS","[A-Z]*"
It is not giving the result.
Thanks,
Ljs
How to search the position of the first alphabet in a alphanemric value.
For eg.
"12345 QRS"
I want the position of the Q , 7
I wrote the Instr function like
pos = Instr("12345 QRS","[A-Z]*"
It is not giving the result.
Thanks,
Ljs