Find the UPPERCASE letter in a string
Array enter (enter using Ctrl-Shift-Enter)
=MIN(IF(ISERROR(FIND(CHAR(ROW(INDIRECT("65:90"))), C2)),"",FIND(CHAR(ROW(INDIRECT("65:90"))),C2)))
HTH,
Bernie
MS Excel MVP
"gritgranite" wrote in message
...
The text string in my cell consists of lowercase alpha and numeric
characters
with the exception of a single UPPERCASE character in the string. The
UPPERCASE character can be in the range A-Z. How can i find the position
of
this UPPERCASE character in the string?
e.g. cell C2 contains "abc2defGhi3j" - i need to find the position of 'G'
cell C3 contains "abC2defghi3j" - i need to find the position of 'C'
and so on for 25k cells
thanks!
|