split xx/yyy into two cells

M

Mike Mike

I got a column like this:
A
25.00/8745
258.00/74
865.50/5
45.89/74
78.17/87586

I need to get the two numbers per cell into each their cell/column:

A B C
25.00/8745 25.00 8745
258.00/74 258.00 74
865.50/5 865.50 5
45.89/74 45.89 74
78.17/87586 78.17 87586

Anyone know how?

Regards
Mike
 
M

Mike Mike

nevermind...
I found this from yesterdays answers:

=TEXT(VALUE(LEFT(A2,SEARCH("/",A2,1)-1)),"#.00")

and

=RIGHT(A2,LEN(A2)-SEARCH("/",A2,1))

Regards
Mike
 
Top