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!
Bookmarks