Split Text into Two Columns

[laingds]

I would like to split the following text in Column A;
Column A
007577................................9-46
007730..............................13-38

In column B, I would like to extract the 9 in row 1, the 13 in row 2
etc.
and in column C I would like to extract 46 in row 1 and the 38 in row
2 etc.

Dale

 

[Don Guillett Excel MVP]

I would like to split the following text in Column A;
Column A
007577................................9-46
007730..............................13-38

In column B, I would like to extract the 9 in row 1, the 13 in row 2
etc.
and in column C I would like to extract 46 in row 1 and the 38 in row
2 etc.

Dale

"If desired, send your file to (e-mail address removed) I will only look
if:
dguillett @gmail.com
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."

 

[Ron Rosenfeld]

I would like to split the following text in Column A;
Column A
007577................................9-46
007730..............................13-38

In column B, I would like to extract the 9 in row 1, the 13 in row 2
etc.
and in column C I would like to extract 46 in row 1 and the 38 in row
2 etc.

Dale

B1:

=TRIM(LEFT(RIGHT(SUBSTITUTE(A1,".",REPT(" ",99)),99),
FIND("-",RIGHT(SUBSTITUTE(A1,".",REPT(" ",99)),99))-1))

C1: =MID(A1,FIND("-",A1)+1,99)