> > >

Excel MCQs

Extract word that begins with specific character as following formula?

=TRIM(LEFT(SUBSTITUTE(MID(txt,FIND("@",txt),LEN(txt)),REPT(" ",100)),100))

=TRIM(LEFT(SUBSTITUTE(MID(txt,FIND("@",LEN(txt))," ",REPT(" ",100),100))

=TRIM(LEFT(SUBSTITUTE(MID(txt,FIND("@",txt),LEN(txt))," ",REPT(" ",100)),100))

=TRIM(LEFT(SUBSTITUTE(MID("txt",FIND("@",LEN(txt))," ",REPT(" ",100),100))

Answer

Correct Answer: =TRIM(LEFT(SUBSTITUTE(MID(txt,FIND("@",txt),LEN(txt))," ",REPT(" ",100)),100))

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