Firstly, what is the feedback on your original request?

Re the Email addresses.
Is it just removing 'Email: ' from the front end of all ?

Why do you need macro rather than use formulas?