Converting All Caps to Proper casing
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: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=498553 |
Converting All Caps to Proper casing
:rolleyes: -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=498553 |
Converting All Caps to Proper casing
Hi
=Proper(A1) Copy down -- Regards Roger Govier "jermsalerms" wrote in message ... :rolleyes: -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=498553 |
All times are GMT +1. The time now is 10:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com