DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=LEFT
|
|
|
=RIGHT
|
|
|
=MID
|
|
|
=PROPER
|
Detailed explanation-1: -The LEFT function returns the specified number of characters from the start, or the left, of a text string. The syntax for the LEFT function looks like this: =LEFT(text, [num chars]). Click in the cell where you want to insert the function.
Detailed explanation-2: -To extract the leftmost characters from a string, use the LEFT function in Excel. To extract a substring (of any length) before the dash, add the FIND function. Explanation: the FIND function finds the position of the dash. Subtract 1 from this result to extract the correct number of leftmost characters.
Detailed explanation-3: -The LEFT function in Excel is a type of text function in Excel that gives the number of characters from the start of the string, from left to right. So, for example, if we use this function as =LEFT ( “ANAND”, 2) this will give us AN as a result.