Using Excel's LEFT(), RIGHT() and MID() Functions

 Certainly! Excel's LEFT(), RIGHT(), and MID() functions are used to extract substrings from a text string based on specific criteria. Here's how to use each function:

LEFT() Function:

Syntax: LEFT(text, [num_chars])

The LEFT() function extracts a specified number of characters from the beginning (left side) of a text string.

text: The text string from which you want to extract characters.

num_chars (optional): The number of characters you want to extract. If omitted, it defaults to 1.

Example: Suppose cell A1 contains the text "Excel". To extract the first two characters (Ex), you would use:

=LEFT(A1, 2)

RIGHT() Function:

Syntax: RIGHT(text, [num_chars])

The RIGHT() function extracts a specified number of characters from the end (right side) of a text string.

text: The text string from which you want to extract characters.

num_chars (optional): The number of characters you want to extract. If omitted, it defaults to 1.

Example: Suppose cell A1 contains the text "Excel". To extract the last two characters (el), you would use:

=RIGHT(A1, 2)

MID() Function:

Syntax: MID(text, start_num, num_chars)

The MID() function extracts a specified number of characters from a text string, starting at a specified position.

text: The text string from which you want to extract characters.

start_num: The position in the text string from which to start extraction.

num_chars: The number of characters you want to extract.

Example: Suppose cell A1 contains the text "Excel". To extract the middle three characters (xce), starting from the second character, you would use:

=RIGHT(A1, 2)

These functions are particularly useful for manipulating text data in Excel, such as extracting parts of strings, parsing data, or performing text-based analysis.