Split Text into Two Columns

L

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
 
D

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
Click to expand...

"If desired, send your file to [email protected] 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."
 
R

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
Click to expand...

B1:

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

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