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