cell C2 imports Last name and suffix in all caps. I need a formula for
cell c3 that will convert it to proper casing

Cell 2 Example:

SMITH JR
SMITH SR
SMITH II
SMITH III
SMITH IV
SMITH MD
SMITH PHD

Cell 3 need to convert to:
Smith Jr
Smith Sr
Smith II
Smith III
Smith IV
Smith MD
Smith PhD

I can't use the funtion PROPER by itself because it converts II to
Ii...etc.


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=498763