Hi

=IF(NOT(ISERROR(FIND("&",A1))),MID(A1,FIND("&",A1) +2,255),"")

--
Regards
Roger Govier

"Imajica12345" wrote in message
...
is there a way to program a macro to remove all characters before "&" in a
cell, or range of cells? At the same time, if a cell does not contain a
"&"
to delete the contents.

Ex.

Mike & Jill would become Jill
Mike would be come ""