Hi Stan,
Glad you're back on track.

If all you did was replace the first letter then F2 then Enter
would probably have worked as well. But using macros usually make
things run a lot faster.

Thank you David.
I went into those cells that weren't working properly,
deleted the first letter, replaced it, hit enter and low and behold,
the cell works like a true e-mail address.