Formula to show only right numbers and letters and other formula to show only left?

[Mr.Castle]

I need a formula to show only right numbers and letters and another to show only left numbers and letters?

Example:

A32= B4:O51

Left is = B4

Right is = O51

Anything before ":" is left and anything after ":" is right,

so left is B4 and right is O51

[azumi]

For LEFT :

=LEFT(A32,SEARCH(":",A32,1)-1)

For RIGHT :

=TRIM(RIGHT(SUBSTITUTE(TRIM(A32),":",REPT(" ",255)),255))

[Mr.Castle]

Thank you, Azumi