Manipulating Strings

**OlYeller21** · 10-06-2009, 01:53 PM

I have a list of email addresses in the first column and they fall into two domains ('@osu.edu' and '@gmail.com'). I need to change all of the '@osu.edu' email addresses to '@buckeyemail.osu.edu' but don't want to do them all by hand. Can this be done with an equation? I know it could be done easily with if/then statements but I'm not good enough with Excel to make that happen.

Any help you could provide would be greatly appreciated.

**NBVC** · 10-06-2009, 01:56 PM

You can go to EDIT|REPLACE

and Replace: @osu.edu

with @buckeyemail.osu.edu

Cick Replace all

**OlYeller21** · 10-06-2009, 01:57 PM

Lol, oh man. Leave it to me to look past the obvious. Thanks :-)

**NBVC** · 10-06-2009, 02:08 PM

You are welcome,

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save