DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Create a formula that returns the two letters from the middle of the vehicle style displayed in cell D4, starting in the 3rd position.
|
|
=LEFT
|
|
|
=RIGHT
|
|
|
=MID
|
|
|
=PROPER
|
Explanation:
Detailed explanation-1: -Excel MID function-syntax and basic uses Generally speaking, the MID function in Excel is designed to pull a substring from the middle of the original text string. Technically speaking, the MID function returns the specified number of characters starting at the position you specify.
Detailed explanation-2: -Enter a Formula 2. To let Excel know that you want to enter a formula, type an equal sign (=). 3. For example, type the formula A1+A2.
There is 1 question to complete.