Google sheets script code that search for all text coincidence I give you and replace with “XXX” : text strings to search:

function replaceText() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var textToSearch = [
“+1204”,
“+1226”,
“+1236”,
“+1249”,
“+1250”,
“+1289”,
“+1306”,
“+1343”,
“+1365”,
“+1367”,
“+1403”,
“+1416”,
“+1418”,
“+1431”,
“+1437”,
“+1438”,
“+1450”,
“+1506”,
“+1514”,
“+1519”,
“+1548”,
“+1579”,
“+1581”,
“+1587”,
“+1604”,
“+1613”,
“+1639”,
“+1647”,
“+1705”,
“+1709”,
“+1778”,
“+1780”,
“+1782”,
“+1807”,
“+1819”,
“+1825”,
“+1867”,
“+1873”,
“+1902”,
“+1905”
];

var range = sheet.getDataRange();
var values = range.getValues();

for (var i = 0; i < values.length; i++) {
for (var j = 0; j < values[i].length; j++) {
var cellValue = values[i][j];

for (var k = 0; k < textToSearch.length; k++) {
var searchText = textToSearch[k];

if (cellValue.toString().indexOf(searchText) !== -1) {
values[i][j] = cellValue.toString().replace(searchText, “XXX”);
}
}
}
}

range.setValues(values);
}

selik

See Full Bio