> > >

Excel MCQs

Which of the following formulas can be used to extract a word containing specific text?

=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),MAX(1,FIND("@",SUBSTITUTE(A1," ",REPT(" ",99)))-50),99))

{=MAX(IF(ISERROR(SEARCH(H5&"*",files)),0,ROW(files)-ROW(INDEX(files,1,1))+1))}

=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),MAX(FIND("*",SUBSTITUTE(A1," ",REPT(" ",99)))-50),99))

=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),MAX(1,FIND(@,SUBSTITUTE(A1," ",REPT(" ",99))-50),99)

Answer

Correct Answer: =TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),MAX(1,FIND("@",SUBSTITUTE(A1," ",REPT(" ",99)))-50),99))

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it