Hi

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

change range to fit your needs

"Lady_Dee" wrote:

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
--
Lady_Dee