Trimming letters in an Excel field
 

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

Trimming letters in an Excel field
 

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

Trimming letters in an Excel field
 

Data/Text to columns
Delimited/ @
--
David Biddulph


"Lady_Dee" wrote in message
...
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