How To Extract All Text Strings After A Specific Text String In Microsoft Excel

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/tips/how-to-extract-all-text-strings-after-a-specific-text-string-in-microsoft-excel-2010.html
SHARE




In this article, you will learn how to extract all text strings after a specific text.

If there is a requirement to retrieve the data from a column after a specific text, we can use a combination of TRIM, MID, SEARCH, LEN functions to get the output.

 

Let us understand with an example:

 

  • We have text in column A, and in column B, we want to get the result & cell D2 contains the criteria or lookup text. Refer below snapshot

img1

 

  • Let us enter word “powerful” in Criteria Text cell D2
  • The formula in cell B2 would be =TRIM(MID(A2,SEARCH($D$2,A2)+LEN($D$2),255))

 
img2

 

  • If we change the Criteria Text say “tool” then, following will be the result (as shown in below screenshot):

img3

In this way, you can get the text strings after a specific text string.

Please follow and like us:
0


Leave a Reply

Your email address will not be published. Required fields are marked *

To avoid automated spam,Please enter the value *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>