How are character patterns in data used to help clean and manipulate data within a cell?

What will be an ideal response?

When trying to clean data in Excel, it is very important to be able to recognize any character patterns in the data that might aid the process. Typical characters that can be used are spaces, hyphens, or commas that are used to separate the text or numeric data in a cell. Using the SEARCH and FIND functions can return the location starting point in a string for the target text string (whether the target is commas, spaces, or other text strings). The results from the FIND and SEARCH functions can then be used or combined with the extraction operators such as REPLACE, RIGHT, LEFT, MID, and SUBSTITUTE to create powerful custom functions to automate the data-cleaning process.