Find the UPPERCASE letter in a string
a single UPPERCASE character in the string
=LOOKUP(1E100,FIND(D$2:D$27,C2))
--
Biff
Microsoft Excel MVP
"Teethless mama" wrote in message
...
Create a helper column D
D2: holds A
D3: holds B
D4: holds C
...D27 holds Z
=FIND(INDEX($D$2:$D$27,MATCH(1,--ISNUMBER(FIND($D$2:$D$27,C2)),)),C2)
Ctrl+Shift+Enter, not just Enter
"gritgranite" wrote:
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!
|