How do I change text from all caps to normal type?
I have text (addresses) that need to be changed from all caps to caps and
lowercase. How do I do this? |
How do I change text from all caps to normal type?
=Proper() HTH -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=553688 |
How do I change text from all caps to normal type?
=Proper() HTH -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=553688 |
How do I change text from all caps to normal type?
Hi Karol,
=PROPER(A1) -- Ken Hudson "Karol" wrote: I have text (addresses) that need to be changed from all caps to caps and lowercase. How do I do this? |
All times are GMT +1. The time now is 08:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com