Finds and removes repeated substrings inside every cell of the chosen range, using user-defined or preset delimiters, while preserving formulas, formatting and Data-validation....preserving formulas, formatting and data-validation. Introduction : Remove...anomaly in obtaining calculation data. Where should we use the Remove...