Excel_beginner
New Member
I have a dataset with 4600 rows. From the location column, which could contain text like this: "Douglas F4D Skyray, Naval Air Station Point Mugu, California, USA"
I wish to extract the country name.
My first solution was to use text to column. However, this doesn't work well since some rows also include state name. This means that the final column with country name will be empty for those rows that have state name.
This is a sample how it can look like. The positive thing is that country name is always last. How can I extract information from the location row and store it in a new column that only shows the country name?
I wish to extract the country name.
My first solution was to use text to column. However, this doesn't work well since some rows also include state name. This means that the final column with country name will be empty for those rows that have state name.
This is a sample how it can look like. The positive thing is that country name is always last. How can I extract information from the location row and store it in a new column that only shows the country name?
Last edited: