LEFT, RIGHT, MID FUNCTIONS

LEFT function:
I have given here about formula syntax and usage of the LEFT function in Microsoft Excel.
 
Description:
LEFT returns the first character or characters in a text string, based on the number of characters you specify.
 
Syntax:
LEFT(text, [num_chars])
The function syntax has the following arguments:
Text    Required. The text string that contains the characters you want to extract.
Num_chars    Optional. Specifies the number of characters you want LEFT to extract.
 
Remark:
Num_chars must be greater than or equal to zero. If num_chars is greater than the length of text, LEFT returns all of text. If num_chars is omitted, it is assumed to be 1.
 
Q:
How to use Left function to bring first name only to the first name column from the full name column?
Type the function as follows in the cell that you would like to get the result in:
=LEFT(A2,5)
 
For more understanding, look at the screenshot please:

 
RIGHT function:
I have given here about the formula syntax and usage of the RIGHT function in Microsoft Excel.
 
Description:
RIGHT returns the last character or characters in a text string, based on the number of characters you specify. RIGHT always counts each character, whether single-byte or double-byte, as 1, no matter what the default language setting is.
 
Syntax:
RIGHT(text,[num_chars])
The RIGHT function has the following arguments:
Text    Required. The text string containing the characters you want to extract.
Num_chars    Optional. Specifies the number of characters you want RIGHT to extract.
 
Remarks:
Num_chars must be greater than or equal to zero. If num_chars is greater than the length of text, RIGHT returns all of text. If num_chars is omitted, it is assumed to be 1.
 
Q:
How to use Right function to bring last name only to the last name column from the full name column?
Type the function as follows in the cell that you would like to get the result in:
=RIGHT(A2,5)
 
For more understanding, look at the screenshot please:

MID function:
This article describes the formula syntax and usage of the MID and MIDB function in Microsoft Excel.
 
Description:
MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
 
Syntax:
MID(text, start_num, num_chars)
 
The MID function syntax has the following arguments:
Text    Required. The text string containing the characters you want to extract.
Start_num    Required. The position of the first character you want to extract in text. The first character in text has start_num 1, and so on.
Num_chars    Required. Specifies the number of characters you want MID to return from text.
 
Remarks:
If start_num is greater than the length of text, MID returns "" (empty text). If start_num is less than the length of text, but start_num plus num_chars exceeds the length of text, MID returns the characters up to the end of text. If start_num is less than 1, MID returns the #VALUE! error value. If num_chars is negative, MID returns the #VALUE! error value. If num_bytes is negative, MIDB returns the #VALUE! error value.
 
Q:
How to use Mid function to bring city only to the City column from the address column?
Type the function as follows in the cell that you would like to get the result in:
=MID(B2,5)
 
For more understanding, look at the screenshot please: