CLEAN
function CLEAN(arg1: string = null): stringDescription
Removes all the nonprintable characters from the text.
Parameters
- arg1
stringdefault: null A string from which nonprintable characters will be removed.
Returns
stringTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.CLEAN("\ntext"));