Need help with text extract formula

**SEMMatt** · 11-09-2014, 07:36 PM

Hello,

Could anyone help me with a formula to break this string out into three columns:

String:

aberdeen (south dakota, united states)

Desired Output:

column a: aberdeen
column b: south dakota
column c: united states

thanks

**Ron Coderre** · 11-09-2014, 07:44 PM

With
A1: your sample text: aberdeen (south dakota, united states)

These regular formulas parse the text into 3 columns
City

A2: =TRIM(LEFT(A1,FIND("(",A1)-1))

State

B2: =TRIM(MID(LEFT(A1,FIND(",",A1)-1),FIND("(",A1)+1,LEN(A1)))

Country

C2: =TRIM(SUBSTITUTE(MID(A1,FIND(",",A1)+1,LEN(A1)),")",""))

Is that something you can work with?

**SEMMatt** · 11-09-2014, 07:52 PM

Ron,

Yes that's great! Thanks

Re: Need help with text extract formula