I imported an excel file into numbers that contains data with names, addresses, phone numbers, etc. The names and addresses are all capitalized and I would like to change them to Title Case. I was able to change the case with Format/Font/Capitalization and I can see the data is changed. However, when I put my curser on the cell I still see the fully capitalized work in the formula/text bar at the bottom of the table. Also, when I export the file as excel or CSV the exported file is back to fully capitalized text. How can I get the font capitalization changes to stick in the exported file?
I want to convert the text in my spreadsheet to title case so I can use the data to mail merge into a letter.