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

Please Login or Register  to view this content.

State

Please Login or Register  to view this content.

Country

Please Login or Register  to view this content.

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