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

B2: =LEFT(A2,FIND("{",A2)-1)
C2: =RIGHT(A2,LEN(A2)-FIND("{",A2)+1)
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Soth" wrote:

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 - Perfect ! You've answer my questions.

Thank you.

"John C" wrote:

B2: =LEFT(A2,FIND("{",A2)-1)
C2: =RIGHT(A2,LEN(A2)-FIND("{",A2)+1)
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Soth" wrote:

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