remove all characters before a certain one
You can acheive this using a formula. With your data in ColA. try this
formula in B1. and copy this down as required...
=IF(ISERROR(FIND("&",A1)),"",TRIM(MID(A1,FIND("&", A1)+1,LEN(A1))))
If this post helps click Yes
---------------
Jacob Skaria
"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 ""
|