Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Capitalise in Excel

Status
Not open for further replies.
Chris22

Chris22

Technical User
Nov 27, 2002
7
GB
Guys,

How can I get the first letter of an entry in every cell of a sheet to be capitalised automatically ??

I have looked at the Autocorrect option in TOOLS and the box is ticked, but it does not seem to do anything.

Regards,

Chris May
 
Sort by date Sort by votes
use the function:

=proper() and input the cells or text in parentheses
[yinyang] Tranpkp [pc2]
 
Upvote 0 Downvote
after setting the Autocorrect option in TOOLS use spell check (F7)
 
Upvote 0 Downvote
I have tried the spell check option (F7) and it does nothing apart from check the spelling. It does not capitalise.

Thanks anyway.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
291
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
287
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
862
shytott
shytott
renigar
  • Question
Excel Power Query refresh error
Replies
3
Views
625
SoftwareRT
SoftwareRT
Andyri
  • Locked
  • Question
Limits in Excel 2
Replies
7
Views
177
Andyri
Andyri

Part and Inventory Search

Sponsor

Back
Top