Log In
Register
Home
New Member
September 19, 2018
Offline
| Hello,
I want to extract country information from cell. Could you please help me on this? A1: A2: Wanted result: B1: B2: |
VIP
Trusted Members
June 25, 2016
Offline
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
New Member
September 19, 2018
Offline
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.
VIP
Trusted Members
June 25, 2016
Offline
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
1 Guest(s)
