|
|
|
Senior Member
|
|
Location: Philippines
Posts: 161
|
|
Quote:
Originally Posted by jjackson3755
I have a list of people with email addresses that I need to use to create usernames. We want the usernames to be everything before the @ symbol. But I cannot figure out a formula that will take the information in the email address column and put the desired username info in another column. Ideas?
|
Let's say A1 has . You can acquire the "somename" by:
=LEFT(A1,FIND("@",A1)-1)
__________________
Asobi Wa Owari Da
|