Script to Find & Replace cells that CONTAIN a certain value

Question

Since Macros do NOT actually record the "Find and Replace" action, I am trying to get a script to find and replace certain strings that can be found in several cells. For example; I have a cell containing "Fred and Joe" and I need to get rid of the "and". In another cell, I may have "Fred, Joe" and I need to get rid of the ",".

I have tried the below, but it only works when the cell ONLY contains "AND". I need the script to ALSO replace the value when the cell CONTAINS the "var f":

}
function FandR(){
  var sh = SpreadsheetApp.getActiveSpreadsheet();
  var ss = sh.getSheetByName("Sheet1");
  var f = "and";
  var r = ",";
  var data = ss.getDataRange().getValues();
  Logger.log(data.length);
  for (var i = 0; i < data[0].length;i++){
    for (var j = 0; j < data.length;j++){
      if(data[j][i]==f)
      ss.getRange(j+1,i+1).setValue(r);
    }
  }  
}

Answer 1

Following you further clarification, I think what you need is:

function FindReplaceMacro() {
  /*
   * Create a regular expression to match
   *   - the string 'and' surrounded by spaces (' and ', ' AND ')
   *   - any non-alphabetic character surrounded by spaces (e.g. ' - ', ' / ', etc.)
   *   - a comma followed by a space (', ')
   */
  var re = / and | \W |, /gi;
  
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getActiveSheet();
  var range = sheet.getDataRange();
  var values = range.getValues();
  
  for (var r = 0; r < values.length; r++) {
    for (var c = 0; c < values[r].length; c++) {
      sheet.getRange(r+1, c+1).setValue(values[r][c].replace(re, ' '));
    }
  }
}

You can test it here (you might need to refresh the page after the macro execution, in order to see the modified data)