You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Can't adjust capitalization settings

I'm trying to adjust a large numbers document so everything is the same type of capitalization (first letter of every word). This is what I am seeing and I don't know how to get it where it is able to be edited. As you can see, there is no way for me to click on the capitalization drop-down. Thanks in advance.

MacBook Pro 13", macOS 10.13

Posted on Jan 21, 2020 6:54 AM

Reply
Question marked as Top-ranking reply

Posted on Jan 21, 2020 7:52 AM

Hi milmor34,


The PROPER function is your friend.

From the Function Browser (type = in any cell to bring up the Function Browser and type proper in the search box)


Insert another column


When all is good, copy the new column and Menu > Edit > Paste Formula Results.

Delete the naughty column.


Regards,

Ian.

3 replies
Question marked as Top-ranking reply

Jan 21, 2020 7:52 AM in response to milmor34

Hi milmor34,


The PROPER function is your friend.

From the Function Browser (type = in any cell to bring up the Function Browser and type proper in the search box)


Insert another column


When all is good, copy the new column and Menu > Edit > Paste Formula Results.

Delete the naughty column.


Regards,

Ian.

Can't adjust capitalization settings

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.