Converting CAPS text to Proper Case

Giganews Newsgroups
Subject: Converting CAPS text to Proper Case
Posted by:  rsantos17 (rsantos17.27ajan_1146759001.2153@excelforum-nospam.com)
Date: Thu, 4 May 2006

Hello all,

I've read this site without registering for some time, but now I have a
question and am hoping someone can help me.

I have a book that has thousands of names all in ALL CAPS, and I was
wondering if there was a way to convert them all to Proper Case? I also
seem to be having trouble converting them one at a time using the
=Proper formula.

Any thoughts.
Much appreciated.
RS

--
rsantos17
------------------------------------------------------------------------
rsantos17's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34124
View this thread:http://www.excelforum.com/showthread.php?threadid=538946

Replies