USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
correct
|
|
|
incorrect
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The FIND function in Excel is used to return the position of a specific character or substring within a text string.
Detailed explanation-2: -FIND Function Part By replacing the specific instance of the character (here let’s say its “c”) with a unique character (“ ”), we can now simply use the FIND function to look for the unique character (“ ”). The FIND function will return the position of that unique character (“ ”) in the text string.
Detailed explanation-3: -The FIND function returns the position (as a number) of one text string inside another. If there is more than one occurrence of the search string, FIND returns the position of the first occurrence. When the text is not found, FIND returns a #VALUE error. Also note, when find text is empty, FIND returns 1.
Detailed explanation-4: -Description. Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document.