Hi,
Although is suggests that if you type a sentence the first letter of the
first word will be capitalized, this is only true in very limit case. Excel
is not a word processor so we need to limit our expectations.
If you test you will see that after you type a sentence ending say with a
period and start a second sentence is the same cell, the first word of that
sentence will capitalize.