Delete all but the information between "-" and ","

[KHGH]

I have a lot of information in one cell:

Region Benelux - Belgium, Region Benelux - Luxembourg, Region Benelux - Netherlands, Region DACH - Austria, Region DACH - Liechtenstein, Region DACH - Switzerland, Region East - Czech, Region East - Greece, Region East - Latvia, Region East - Poland, Region East - Romania, Region East - Slovakia, Region France - France, Region Iberia - Spain, Region Italy - Italy, Region North - Ireland, Region North - Sweden, Region North - UK, South Africa & Francophone Africa - South Africa

I would like to find a formula to delete all but the name of the country, that is the information between the "-" and the "," and put all the remaining country words in individual cells of one row.

Thanks!

[AliGW]

Welcome to the forum.

Results to be in one cell, or in a separate cell for each country?

[alansidman]

Is your data all in one column? In one row? Multiple rows? Suggest your read the yellow banner at the top of this page on how to attach a file so that we better understand your workbook layout.

[KHGH]

Hey!
Results to be in separate cells of a row.

[KHGH]

The data is in one cell and I would like to have the extracted strings in indiviudal cells of one row.

[AliGW]

Try this in B2 drag copied across:

=LEFT(TRIM(MID(SUBSTITUTE($A1,"-",REPT(" ",1000)),1000*(COLUMNS($A:A))+1,1000)),FIND(",",TRIM(MID(SUBSTITUTE($A1,"-",REPT(" ",1000)),1000*(COLUMNS($A:A))+1,1000)))-1)

For your French locale, you may need to change commas to semi-colons.

[KHGH]

Thank you so much. This works well.

An additional question:
What if there are more of these cells in a column, and I would like to do the same as above for all these cells, but put the results in individual cells of columns (one column per cell)?

Thanks again, much appreciated.

[AliGW]

Just drag copy the formula down the column.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[KHGH]

Cool, thank you.

One last question: How could I do the same and keep the result in one cell?

Thanks!