|
| |
|
|
sentinel
Posts: 568
Joined: 5/4/2005
From: Chicago, Illinois
Status: offline
 |
Excel merges - 11/14/2005 12:15:15
hey all...
I have an excel spreadsheet that has a first name, last name, username and phone colum.
Our email system uses a format like this
first name . lastname @ company.com
how can i take the firstname column, move it to another cell, add a period, add thelast name column then put a @company.com after all of it?
I have about 20,000 records to do and am looking for an easy way.
Thanks
_____________________________
No matter where you go, there you are.
|
|
|
|
danrendrag
Posts: 24
Joined: 6/2/2004
From: Atlanta, Georgia USA
Status: offline
|
RE: Excel merges - 11/14/2005 12:58:48
The easiest way would be to use the Concatenate() function in an adjacent cell.
You can find examples of its use in the help files.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
