How do I grab everything in an email address before the @ sign?<BR>Ltrim?
No - LTrim removes leading whitespace. What you want is:<BR><BR>Left(strEmail, InStr(strEmail, "@"))<BR><BR>You may need to add 1 to the InStr() result - I can never remember (shoddy since I do it all the time...)<BR><BR>Dunc
I still get the @ and I added the one?
Ooops! Too late in the day...<BR><BR>Try subtracting one instead (plus, minus, who cares...)<BR><BR>Dunc