Display text function

[Ofirabo]

Hello,

I have a list of an email adress, i want to display on a different coulmn
all until the "@"
i.e : ofira.sharon@gmail.com the result will be : ofira.sharon

what function should i use?

Many thanks

Ofira​

 

[mikerickson]

How about
=TRIM(LEFT(REPLACE(A1,"@",REPT(" ",255)),255))

Alternatly, you could use TextToColumns with a @ delimiter.

 

[jrabi]

Copy the email listing to a new column and use the replace function, replace @gmail.com with blank.........