ExcelBanter - How to change case on a spreadsheet from Caps to Sentence?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to change case on a spreadsheet from Caps to Sentence? (https://www.excelbanter.com/excel-discussion-misc-queries/33866-how-change-case-spreadsheet-caps-sentence.html)

Mamacsee

How to change case on a spreadsheet from Caps to Sentence?

I am trying to change text on my spreadsheet from all CAPS to Title Case

check Proper() function

"Mamacsee" wrote:

I am trying to change text on my spreadsheet from all CAPS to Title Case

All times are GMT +1. The time now is 09:59 AM.