VB to get left of email address @ sign

[Martyn12]

Hi
Hope someone can assist, I have an Excel book that has VB to email out when certain criteria is met. in this it will put into the body of the email the users email address, but I would like it to only to show FirstName.LastName (or to the left of the @ sign)

This is the bit of the VB that for cell "B", which shows the email address:

" Requested By:- " & Cells(FormulaCell.Row, "B").Value & _<strike></strike>

is there anyway the VB can do the above.

Many thanks

 

[Peter_SSs]

Does this do what you want?

... " Requested By:- " & Split(Cells(Formulacell.Row, "B").Value, "@")(0) ....

 

[Martyn12]

Does this do what you want?

... " Requested By:- " & Split(Cells(Formulacell.Row, "B").Value, "@")(0) ....

Brilliant
Many Thanks Peter for quick response

 

[Peter_SSs]

Brilliant
Many Thanks Peter for quick response

You are welcome. Thanks for the confirmation.