Excel Formula : RIGHT / LEFT / MID / LEN

 RIGHT: The RIGHT function in Excel allows you to extract a certain number of characters from the right end of a text string. The syntax of the RIGHT function is =RIGHT(text, [num_chars]). The "text" is the cell containing the text string, and [num_chars] is the number of characters you want to extract.

LEFT: The LEFT function in Excel allows you to extract a certain number of characters from the left end of a text string. The syntax of the LEFT function is =LEFT(text, [num_chars]). The "text" is the cell containing the text string, and [num_chars] is the number of characters you want to extract.

MID: The MID function in Excel allows you to extract a certain number of characters from a text string, starting from a specified position. The syntax of the MID function is =MID(text, start_num, num_chars). The "text" is the cell containing the text string, "start_num" is the position at which you want to start extracting characters, and "num_chars" is the number of characters you want to extract.

LEN: The LEN function in Excel returns the number of characters in a text string. The syntax of the LEN function is =LEN(text). The "text" is the cell containing the text string.

These formulas are useful when you have to manipulate text data, like cleaning, formating or just analyzing the data. They are widely used in data preparation, data analysis, and reporting tasks.