Splitting numbers and text to their respective columns

[RAM72]

Hi All

Need help to splitting numbers and text separately to their respective columns

Annexed file for reference

thanks

 

[Hui]

If all the entries purely have "ea"
B3: =LEFT(A3,LEN(A3)-2)
C3: =RIGHT(A3,2)

But if you have other units I'd suggest
B3: =LEFT(A3,FIND(".",A3)+2)
C3: =RIGHT(A3,LEN(A3)-LEN(B3))

Copy both equations down

 

[RAM72]

Hi Hui

Thank you both formula works very well

Regards