Nashattack All American 7022 Posts user info edit post |
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 |
Ernie All American 45943 Posts user info edit post |
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 |