If you could use a helper column, you could fill it with formulas like:
=TRIM(MID(A1,SEARCH("&",A1&"&")+1,LEN(A1)))



Imajica12345 wrote:

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 ""

--

Dave Peterson