Hi there I know the PROPER function will convert all text to capitalise each word, is there a formula that can convert only the first letter to caps and the rest to lower case?
Thanks
Simon
Hi there I know the PROPER function will convert all text to capitalise each word, is there a formula that can convert only the first letter to caps and the rest to lower case?
Thanks
Simon
Last edited by simjambra; 03-12-2009 at 08:31 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks