Excel 2000 without add-ons
I have two cells that contains text cell1:"20/30" and cell2: "45/100"
I would like two formulas that combines the first part, or the second
part of the cells and gives me the result "20/45"and in another cell
"30/100"
This I could do with the formulas
=LEFT(cell1,2)&"/"& LEFT(cell2,2)
And
=RIGHT(cell1,2)&"/"& RIGHT(cell2,3)

The problem I have is that the cells I would like to combine can have
different number of characters for example "1/50" and "33/888" In this
case I would like the result "1/33" and "50/888"
There can be minimum" 0/10 and 0/100" and maximum "99/99 and 999/999"
in the cells I would like to combine.

Can anyone help me with the two formulas that I'm looking for?

Thanks!