Extract only the text that interests me

[RuiC.]

Good morning everyone,

I have a set of cells containing text, wanted a way to extract only the text that interests me.
The list in question is related to a series of football matches, which is presented in various market information and the teams that will face, in this case I just want the names of the teams, separated by cells.
Attached a picture with an example to better understand
regards,
Rui


Exemple:

Excel Problem.JPG

[benishiryo]

welcome to the forum, RuiC. it's better you upload a sample Excel file next time. try this in B4:
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(REPLACE($A4,1,FIND(" - ",$A4)+2,"")," x ",REPT(" ",100))," v ",REPT(" ",100)),1+(COLUMNS($B4:B4)-1)*100,100))

copy over to C4. not sure if you use semi-colons instead of commas. if so, change all commas to semi-colons. to attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[RuiC.]

Good Morning Friend benishiryo,

I thank you greatly for your help.
However in a few lines the team's name is returned with the information of the championship.
Will you help me with that?
Along excel sheet to facilitate.
I use semicolons.

thank you
Rui

[benishiryo]

based on current data, maybe:

Please Login or Register  to view this content.

what i have done in simple terms is to remove everything before the last " - ". i then split up everything before " v " or " x ". so if there's more data you have a problem with, it means that it doesnt meet these criteria.

[RuiC.]

Thank you for your help, now resulted five stars. *****
Who knows deserves all the credit, as is the case.

My best regards,
Rui