How to adapt this function to exclude a specific cell or how to apply just to one cell?
function onEdit(e) {
if (typeof e.value != 'object') {
e.range.setValue(e.value.toUpperCase());
}
}
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityHow to adapt this function to exclude a specific cell or how to apply just to one cell?
function onEdit(e) {
if (typeof e.value != 'object') {
e.range.setValue(e.value.toUpperCase());
}
}
Convert a text of a specific cell ... to UPPERCASE
function onEdit(e) {
var sheet, sheetName, colToCapitalize;
sheet = e.source.getActiveSheet();
colToCapitalize = 1;
sheetName = 'Sheet1';
if (sheet.getName() !== sheetName || e.range.rowStart = 2 || e.range.columnStart !== colToCapitalize || typeof e.value == 'object') return;
e.range.setValue(e.value.toUpperCase())
}