Have an excel spreadsheet with email addresses (and lots of them). This list is an old backup. Now I have a new membership site which allows me to use Excel to import members. However, I need to have the data in "import" columns so it can be mapped correctly to the new software. I can do that fairly easily but the column which is problematic is the User Name column. The new software requires one whereas the old backup software didn't so I don't have a unique user name for each person's email address. I was thinking I could do username@domain.com and simply harvest the "username" from the email address as the username. I cannot use the email address due to other restrictions in the software. Is there an easy routine to create a column with just the first part of the email address listed and dropping the @domain.com? Of course, none of the email addresses are from the same domain--their all random except for the "at" symbol. I have roughly 60,000 email addresses. Any ideas?