PROPER
function PROPER(arg1: string = null): stringDescription
Converts a text string to proper case: the first letter in each word to uppercase, and all other letters to lowercase.
Parameters
- arg1
stringdefault: null The text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing text to partially capitalize.
Returns
stringTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.PROPER("dAVID CONNOR"));