Function to separate numbers divided with a /

[MaddogJason]

I need a function that separates numbers in a cell.
For example, I have 12/40 in a cell, and I would need the 12 and 40 in two different cells.
I need a function for this, so the Data tab is not enough.

 

[Fluff]

How about

=TEXTSPLIT(A2,"/")

 

[Misca]

Try the new TEXTSPLIT function in Excel 365. Just add a double negative before the TEXTSPLIT and you'll get actual numbers instead of text.