DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following function can be used to extract first name if the name has following format Shah Sahil i.e. LastName FirstName
|
|
left( )
|
|
|
right( )
|
|
|
both of the above
|
|
|
none of the above
|
Explanation:
Detailed explanation-1: -LEFT returns the first character or characters in a text string, based on the number of characters you specify. LEFTB returns the first character or characters in a text string, based on the number of bytes you specify.
Detailed explanation-2: -Enter the formula of =RIGHT(A2, LEN(A2)-FIND(” “, A2, 1)) in another blank cell, Cell C2 in this case. 3. Copy those two formulas down and you will see the full name column is split to the first name and last name columns as shown below.
There is 1 question to complete.