I apologize as I feel this is a total novice question, but I'm in a bit of a jam.

Long story short... I have a column in Excel where I have email addresses that need 1 character to increase by 1 number. In other words....

Email1@yahoo.com
Email2@yahoo.com
Email3@yahoo.com
Email4@yahoo.com

etc, etc,

Surely there is a formula to do this quickly/easily? Thank you gurus! I appreciate it greatly