ExcelBanter - Change case from UPPER to Title Case??

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

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

- - Change case from UPPER to Title Case?? (https://www.excelbanter.com/excel-discussion-misc-queries/33874-change-case-upper-title-case.html)

Mamacsee

Change case from UPPER to Title Case??

Nick Hodge

Check out the PROPER function

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Mamacsee" wrote in message
...

Anne Troy

You can use =Proper(a1) to change cell A1 from upper case to "title" case.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

"Mamacsee" wrote in message
...

All times are GMT +1. The time now is 06:09 PM.