
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)
