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
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.
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.
Thanks, Ian. Great as always. I am going to be posting a follow-up question in regards to cell formatting so i'm sure i'll be hearing from you again soon. Thanks.
Glad to help 😊
Thanks for the greenie and your feedback. Keep posting in Numbers for Mac.
Regards,
Ian.
Can't adjust capitalization settings
