ExcelBanter - how can I change case to Proper on a worksheet

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

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

- - how can I change case to Proper on a worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/25488-how-can-i-change-case-proper-worksheet.html)

PlsHelp

how can I change case to Proper on a worksheet

I have an excel file that is all caps and want to change the case to proper

JE McGimpsey

Take a look he

http://www.mvps.org/dmcritchie/excel/proper.htm

In article ,
"PlsHelp" wrote:

I have an excel file that is all caps and want to change the case to proper

rosalindvt

You can also export to a .CSV, open the .CSV in MS Word, Use "Change Case" to
change to Title Case, and then re-import into Excel.

"PlsHelp" wrote:

I have an excel file that is all caps and want to change the case to proper

All times are GMT +1. The time now is 07:40 AM.