It will depend if all countries are two-worded like in your examples.

If not then it may be a bit difficult.What is the text after the country's name?

Better if you could provide more dummy data in a attachment for us to take a look.

Sunny

Not all countries are two worded.

The text after the country might be various. There are no specific word or symbol after country information.

But this text starts in new line.

Give this a try. Not too sure if it will work under all circumstances.

I am assuming that CHAR(10) is used to break the line. You may need to change this if it is different.

Columns B-E are the detailed step-by-step workings. Column F is the mega formula (all in one)

Hope this helps.

Sunny