New Member
September 19, 2018
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
VIP
Trusted Members
June 25, 2016
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)