Home / Microsoft Excel / Question
MCQ
Which function returns the text before a given delimiter?
Microsoft Excel
A TEXTBEFORE
B TEXTAFTER
C LEFT
D MID
Explanation

TEXTBEFORE extracts text preceding a separator.

Related MCQs

Which function counts cells that meet a specified condition?
Microsoft Excel View
Which function returns a custom value when a formula produces an error?
Microsoft Excel View
Which function extracts characters from the left of text?
Microsoft Excel View
Which function returns the remainder after division?
Microsoft Excel View
Which function searches for a value in the top row of a table?
Microsoft Excel View
What is sorting in Excel?
Microsoft Excel View