capitalize first letter automatically

R

raft

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

Bob I

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

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
 
B

Bob I

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

Gord Dibben

Thanks Bob.

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

Live and learn.


Gord
 
Top