ExcelBanter - Auto change all caps to upper and lower case

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

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

- - Auto change all caps to upper and lower case (https://www.excelbanter.com/excel-discussion-misc-queries/219287-auto-change-all-caps-upper-lower-case.html)

Roberson

Auto change all caps to upper and lower case

I received a spreadsheet with 500 names that need to be merged into labels.
Entries are in all caps. Is there a way to convert names into proper upper
and lower case without re-entering them? Using 2003 XP.

David Biddulph[_2_]

Auto change all caps to upper and lower case

Look in Excel help at the PROPER function (also UPPER and LOWER).
--
David Biddulph

Roberson wrote:
I received a spreadsheet with 500 names that need to be merged into
labels. Entries are in all caps. Is there a way to convert names
into proper upper and lower case without re-entering them? Using
2003 XP.

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