I have text (addresses) that need to be changed from all caps to caps and
lowercase. How do I do this?
I have text (addresses) that need to be changed from all caps to caps and
lowercase. How do I do this?
=Proper()
HTH
Google is your best friend!
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks