In Excel, which function would you use to find the position of 'at' in the text 'Education'?
A. SEARCH("at", "Education")
B. MATCH("at", "Education")
C. FIND("at", "Education")
D. Both A and B
Answer: Option D
Solution (By JKSSB Mock Tests)
Both SEARCH and FIND return the starting position. SEARCH is case-insensitive, FIND is case-sensitive.
No comments yet. Be the first to start the discussion!