Find a word between a string (sentence) using Excel

Excel Coulmn A1   “Get me If you can “

 

=MID(A1,SEARCH(“Get”,A1)+3,SEARCH(“If”,A1)-SEARCH(“Get”,A1)-4)

Add Comment