Trimming letters in an Excel field

[Lady_Dee]

I have email addresses that contains the first name, I need to trim up to the
character "@" in each and retrieve each name in a separate column. Please
help

 

[Eduardo]

Hi

=TRIM(LEFT(B12,FIND("@",B12)-1))

change range to fit your needs

 

[David Biddulph]

Data/Text to columns
Delimited/ @