Sorry, I did reply to my first thread. You macro did worked. I guess it did not get posted. Thanks again.

RE: Email... yes it is just to remove the word email: from the front along with the space. As for formulas, I do not know them.