LEFT, RIGHT, MID, LEN Formula in MS Excel

 LEFT, RIGHT, MID, LEN Formula in MS Excel

The LEFT, RIGHT, MID, and LEN formulas in MS Excel are used to manipulate text in a cell.

The syntax of the LEFT formula is as follows:

LEFT(text, [num_chars])

Where:

• text: The text from which you want to extract characters.
• [num_chars]: Optional. The number of characters to extract from the text. If this argument is omitted, the formula returns 1 character.

For example, the following formula would extract the first 3 characters from the text in cell A1:

=LEFT(A1, 3)

The syntax of the RIGHT formula is as follows:

RIGHT(text, [num_chars])

Where:

• text: The text from which you want to extract characters.
• [num_chars]: Optional. The number of characters to extract from the text. If this argument is omitted, the formula returns 1 character.

For example, the following formula would extract the last 3 characters from the text in cell A1:

=RIGHT(A1, 3)

The syntax of the MID formula is as follows:

MID(text, start_num, [num_chars])

Where:

• text: The text from which you want to extract characters.
• start_num: The position of the first character to extract.
• [num_chars]: Optional. The number of characters to extract from the text. If this argument is omitted, the formula returns all characters to the end of the text.

For example, the following formula would extract the characters in the range from the 4th to the 6th character of the text in cell A1:

=MID(A1, 4, 3)

The syntax of the LEN formula is as follows:

LEN(text)

Where:

• text: The text for which you want to find the length.

For example, the following formula would return the length of the text in cell A1:

=LEN(A1)