View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gritgranite gritgranite is offline
external usenet poster
 
Posts: 1
Default Find the UPPERCASE letter in a string

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!