Formula creation

[Soth]

Hello,

1. 5-23{AROOSTOOK}
2. 0016-0017{WALDO}
3. 14-54{SOMERSET}
4. 0022-0085{YORK}
5. 10-165{HANCOCK}

I'm interested in a formula for the above problem. I'd like to separate the
above numbers and characters in a different column. Example 1. It should be
like this - column B is 5-23, column C is {AROOSTOOK}
The number length is varying.

Thank you for your help.
Sothea

 

[John C]

B2: =LEFT(A2,FIND("{",A2)-1)
C2: =RIGHT(A2,LEN(A2)-FIND("{",A2)+1)

 

[Soth]

John - Perfect ! You've answer my questions.

Thank you.