How to extract multiple words in middle of the cell

[AlaaJ]

Hi

I facing an issue in extract words between some specific word
for example:

I am studying in <start:loc> London <end> but I live with my mother in <start:loc> Manchester <end> and in vacation I go to <start:loc> Cardiff <end>

I want to extract the word between tags <start:loc> <end> in one cell

I tried Mid, right, left, VBA but did not work I got London but I cannot get the rest.
Please could you help to extract words in this way London; Manchester;Cardiff

 

[XOR LX]

Re: How to extract multiple words in meddle of the cell

Hi,

What do you mean by "between tags"? I see no "tags" in that sentence.

If there are no physical delimiters present around the desired extractions, can you clarify the logic that determines which words are to be extracted? One would hope that it would be a bit less vague than, for example, "Extract all towns/cities within the sentence", which would be nigh on impossible.

Regards

 

[AlaaJ]

Re: How to extract multiple words in meddle of the cell

Hi,

What do you mean by "between tags"? I see no "tags" in that sentence.

If there are no physical delimiters present around the desired extractions, can you clarify the logic that determines which words are to be extracted? One would hope that it would be a bit less vague than, for example, "Extract all towns/cities within the sentence", which would be nigh on impossible.

Regards

I mean by tags (<START:LOC><END>)so I would take words in between. Is not necessary to be city
I used this formula
=MID(B2,FIND("<START:LOC>",B2)+1,FIND("<END>",B2)-FIND("<START:LOC>",B2)-1)

 

[Fluff]

Re: How to extract multiple words in meddle of the cell

The board software interpreted the tags as HTML & removed them, I have edited the op to show the tags.


@AlaaJ
When posting anything that contains either < or > symbols you need to add spaces either side.

 

[AlaaJ]

Re: How to extract multiple words in meddle of the cell

The board software interpreted the tags as HTML & removed them, I have edited the op to show the tags.


@AlaaJ
When posting anything that contains either < or > symbols you need to add spaces either side.

oh thanks

I mean by tags (< START:LOC > < END > <start:loc style="color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);"><end>)so I would take words in between. Is not necessary to be city
I used this formula
=MID(B2,FIND("< START:LOC ><start:loc>"</start:loc>,B2)+1,FIND("< END ><end>"</end>,B2)-FIND("< START:LOC ><start:loc>"</start:loc>,B2)-1)</end></start:loc>