Someone sent me a very large spreadsheet entirely in uppercase. Extremely hard to read. is there an easy way to change a range of cells from uppercase to proper case. Using Excel 2007
If you really mean Proper then
=PROPER(A1)
will do it but that capitalises the first letter of every word which is an
improvement on all caps but not ideal.
Fir a solution try here http://www.mvps.org/dmcritchie/excel/proper.htm#proper
If you really mean Proper then
=PROPER(A1)
will do it but that capitalises the first letter of every word which is an
improvement on all caps but not ideal.
Fir a solution try here http://www.mvps.org/dmcritchie/excel/proper.htm#proper
Mike
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.