Help ME PLZ

i Have A file Which contains the names like this

Lokesh & Chitra
Adam & EVE
Paul & Nina

i want to remove the name and space before and after from "&" so my name look like this

Chitra
EVE
Nina

Plz Help Me.

Nick's picture

formula

you need a formula like this:

=RIGHT(A1,LEN(A1)-FIND("&",A1,1)-1)

Where:  Lokesh & Chitra    is in cell A1