capitalize first letter automatically

[raft]

i tried tools menue- autocorrect options - autocorrect - captalize first
letter.. but it didn't work

 

[Bob I]

The option is "Capitalize first letter of sentences". Excel doesn't have
a concept of "sentences".

 

[Gord Dibben]

But it will capitalize the first word after a full stop.

Type qwerty. asdfgh and Excel will change it to qwerty. Asdfgh

Strange doin's


Gord Dibben MS Excel MVP

 

[Bob I]

Solved. It simply capitalizes the first character after a ". " (period
space combo. Still doesn't know what a "sentence" is. ;-)

 

[Gord Dibben]

Thanks Bob.

I tested with .qwerty but not with .<space>qwerty.

Live and learn.


Gord

 

[Bob I]

NP, just knew had to be some kind of logic behind the behavior one observes.