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
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
Hi
=Proper(A1)
Copy down
--
Regards
Roger Govier
"jermsalerms" <[email protected]>
wrote in message
news:[email protected]...
>
>
>
>
> --
> jermsalerms
> ------------------------------------------------------------------------
> jermsalerms's Profile:
> http://www.excelforum.com/member.php...o&userid=30167
> View this thread:
> http://www.excelforum.com/showthread...hreadid=498553
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks