Brilliant Naomi !! I will use this. Sorry I was trying out the ATC() function and was truly happy with that until I tried your remedy.- it's perfect.
k
>>I am trying to extract the characters BEFORE the @ in an email - is there a single line or simple two step code that can do this?
>>example
>>name_of_sender@thisemail.com
>>
>>I would like only the "name_of_sender"
>>
>>I know the long way round - searching for the '@' by counting characters in a for - endfor loop
>>perhaps a len() that counts to the @ - something along those lines.
>>
>>thanks
>>k
>
>Try:
>
>var = 'name_of_sender@thisemail.com'
>
>=MESSAGEBOX(LEFT(var, AT('@', var + '@')-1))