Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
litLIB: added the InitCap function (Read 1872 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
litLIB: added the InitCap function
04.12.09 at 13:48:33
 
litLIB: added the InitCap function
 
The InitCap function was added to the litLIB power functions library for Excel (download litLIB)  
 
InitCap will convert the first character of each word in the string to upper case and the remainder of the word to lower case.
 
=InitCap("jamie oliver")
Result: Jamie Oliver
 
See also:
litLIB's InitCap function
http://www.oraxcel.com/projects/litlib/help/initcap.html
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1