What are Text functions? How are they used for cleaning data?

What will be an ideal response?

Text functions refer to a large family of functions in Excel that are used for manipulating text strings. Text strings represent data that is stored in the cells of a spreadsheet and can include text, numbers, and dates. These functions help you clean the data by removing unnecessary spaces, changing capitalization of text, changing the arrangement order of the text, and searching for and extracting text data strings.