ExcelBanter - Function Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Function Help (https://www.excelbanter.com/excel-worksheet-functions/265970-function-help.html)

jjackson3755

Function Help

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?

wickedchew

Quote:

Originally Posted by jjackson3755 (Post 959541)

Let's say A1 has . You can acquire the "somename" by:

=LEFT(A1,FIND("@",A1)-1)

All times are GMT +1. The time now is 05:05 AM.