..
"FLKulchar" skrev i en meddelelse
...
Hello:

All I know is that the formulae work...I am F. L. Kulchar...I started the
queries.

I want to thank all of you for your unbelievably intelligent input...I
wish I could be "near" you so I could learn more.

FLKulchar


Hello FLKulchar

For a formula solution, which also works for local alphabets, try this one:

=SMALL(IF(EXACT(PROPER(MID(A1,ROW(INDIRECT("1:"&LE N(A1))),1)),
MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),ROW(INDIREC T("1:"&LEN(A1)))),1)

This is an array formula, which must be entered with
<Shift<Ctrl<Enter instead of just <Enter

--
Best regards
Leo Heuser

Followup to newsgroup only please