Extract multiple words from a cell in excel (solved)

[rituraj851]

Hello Everyone,

I am trying to extract certain words which starts from VRM in the cell. I've used below function but it extracts only the first instance where the condition is met and leaves the rest of word where the condition is met. I've attached a copy of the sample data for your reference.

 

[bosco_yip]

What is your Excel version?

 

[Chihiro]

Cross posted.
Please read rules below.

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

 

[Juniad]

Try this in Cell C2
=MID(A2,SEARCH("VRM",A2),SEARCH("-",A2,SEARCH("VRM",A2))-SEARCH("VRM",A2))
and in Cell D2
=TEXTJOIN(",",TRUE,TEXTBEFORE(TEXTSPLIT(B2,,CHAR(10)),"-"))

 

[p45cal]

@Juniad 's formulae in columns G & H in the attached (with a tweak or two to make the results exactly as the 'required output' - see G9:H13 which checks this)
and for good measure, a Power Query version in columns J & K (right-click and choose Refresh if you change the source data) with similar checks in J9:K13.

 

[rituraj851]

What is your Excel version?

O365

 

[vletm]

Moderator Note:
rituraj851
Did You read #3 reply?
Those rules are for You too.

You replied that You're new here ... then of course Your first steps has been to check next link

There are those Forum rules.
Same kind of rules are in every Forum.

Is this thread solved?

 

[rituraj851]

Moderator Note:
rituraj851
Did You read #3 reply?
Those rules are for You too.

Noted. I will ensure going forward mentioning cross post if there is any. As I am new here was not aware of the forum rules. Also, could you please help me in understand on how to mark this post as solved.