User not logged in - login - register
Home Calendar Books School Tool Photo Gallery Message Boards Users Statistics Advertise Site Info
go to bottom | |
 Message Boards » » Excel question Page [1]  
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

Nashattack
All American
7022 Posts
user info
edit post

Very cool.. thanks!

6/16/2009 12:07:03 PM

 Message Boards » Tech Talk » Excel question Page [1]  
go to top | |
Admin Options : move topic | lock topic

© 2024 by The Wolf Web - All Rights Reserved.
The material located at this site is not endorsed, sponsored or provided by or on behalf of North Carolina State University.
Powered by CrazyWeb v2.39 - our disclaimer.