I have a column of usernames (i.e. pa41, barka003, mb229, etc)... I need to have a phrase added to the end of each of them so the column reads pa41@yahoo.com, barka003@yahoo.com, etc). All of them will be @yahoo.com

I tried Find and Replace, but that doesn't really work or I'm not doing it right.

Obviously, those aren't real usernames and I'm not really doing it for @yahoo.com, but I don't want to give away any personal information.

Thanks

6/16/2009 11:31:45 AM

Create a new column, set the first cell = A1&"@yahoo.com", where A1 is in the column that contains the usernames, fill down, copy values to new column, delete column with formula. Crude, but workable.

6/16/2009 11:34:09 AM

Very cool.. thanks!

6/16/2009 12:07:03 PM