formula to split 23>34 23 > 34 in there own cells?

[tonywatsonhelp]

Hi Everyone,

I need a formula / formula to split a cell into 3

besicly I want everything before ">" in first cell, Everything after ">" in second cell

so if its "254.67>32.45" I get 254.67 and 32.45

please help

Thanks

Tony

 

[Nishant94]

Unknown
	A	B	C
1		1st No.	2nd No.
2	254.67>32.45	254.67	32.45
3
Sheet2

Cell Formulas
Range	Formula
B2	=LEFT(A2,FIND(">",A2)-1)+0
C2	=SUBSTITUTE(A2,B2&">","")+0

 

[tonywatsonhelp]

Thank you very much Nishant94