How do I correct the text case of data that is in ALL CAPS to PROPER capitalization form.
H halljlsampeck Feb 15, 2005 #1 How do I correct the text case of data that is in ALL CAPS to PROPER capitalization form.
P Paul B Feb 15, 2005 #2 One way, =PROPER(A1) and copy down -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003
One way, =PROPER(A1) and copy down -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003
