How to handle Country Name with 2 words

Hello all!,

Can someone please offer assistance to this code to achieve what I need.

The code works as wanted but now I want to extract the country name, so I copied the extract frequency part down to the country section, it works with a country name of one word like Iran, or Greece, but it's not working for two word country name like United Kingdom or Saudi Arabia.

Can someone offer help to get over this hurdle to handle 2 part country names.

Thanks!

Hi Fredlo 2010,

Thanks for the reply!!
I ran your code on the demo I upload and indeed it does extract the country name as I want.

The issue I am trying to resolve is to incorporate your code into my code to do the same thing. If you look at my code, it inserts 3 columns at A so the details which contains the country name is under column D.
After the frequency is extract from column D and placed under column A, the frequency is removed from column D, this is when the bold format on the country name is removed for some reason.

How do I add in your code to work so country name falls under column C?

Fredlo2010,

Thanks for the time you have spent on this for me, it's really appreciated!!
I believe we are really close now to what I need, there are two items needed to complete this project.

1. My original code had 2 columns inserted, one for the Frequency, one for the name of the current tab and now you have given me the Country name. I need the third column inserted at column B for the tab name with country name at column C!
So, it should read Freq, Issue, Country, Details
[ATTACH]
348814
[/ATTACH]

2. My original code would extract the frequency from the data and insert under column A which is what you have done, but I need the Frequency and the country name removed from the detail!

Can you add this to the code for me?

Thanks

Thanks Fredlo2010!!
I understand!

Hi Fredlo2010,

Thanks for the updated code script.
When I run the updated script on the Demo file I supplied as an attachment, it runs as requested!!

Then, when I run against the actual data file, I seem to be getting an error "run time error 5 invalid procedure call or argument" at this line

Cells(i, 3).Value = Right$(Cells(i, 3).Value, Len(Cells(i, 3).Value) - (InStr(1, Cells(i, 3).Value, Cells(i, 3).Value) + Len(Cells(i, 3).Value)))

I am not too sure what is going on!

Thanks Fredlo2010!!
I appreciate your help on my project!!