Position of Last Upper Case Letter found

Not the most elegent of formulas but this works:

=MAX(IF(IFERROR(IF(FIND(IF(MID(A1,ROW($1:$99),1)<>" ",MID(A1,ROW($1:$99),1)),UPPER(MID(A1,ROW($1:$99),1))),ROW($1:$99)),FALSE)<=LEN(A1),ROW($1:$99)))

Here's another one.

Your formula will return an incorrect result if there are non-letter characters in the string (if that's a possibility). For example:

I don't like onions.
You Owe Us $100

This array formula accounts for non-letter chars.

=MAX(IF(ABS(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))-77.5)<13,ROW(INDIRECT("1:"&LEN(A1)))))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

If the referenced cell is empty then you'll get a #REF! error which can be accounted for if needed.

There may also be instances where the formula will return 0 meaning no uppercase letters are present. If you don't want a result of 0 this can also be accounted for if needed.

Really nice, Tony.

I particularly like the use of ABS and < as one condition in place of two (< and >). Excellent stuff.

Thanks!