software

Data is imported to cell A1 in all Caps

I need cell A2 to convert everything to proper casing

Cell A1 reads - 123 MAIN STREET APT 321
Cell A2 needs to convert this to - 123 Main Street Apt 321--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: www.excelforum.com/member.php...oamp;userid=30167
View this thread: www.excelforum.com/showthread...hreadid=498553
--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: www.excelforum.com/member.php...oamp;userid=30167
View this thread: www.excelforum.com/showthread...hreadid=498553Hi

=Proper(A1)
Copy down

--
Regards

Roger Govierquot;jermsalermsquot; gt;
wrote in message
...
gt;
gt;
gt;
gt;
gt; --
gt; jermsalerms
gt; ------------------------------------------------------------------------
gt; jermsalerms's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30167
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=498553
gt;