Theresa has attended:
Excel VBA Intro Intermediate course
StrName
Hi,
in my selection data my strName currently = theresa.carey@ticketmaster.co.uk (i also have a number of other names in my selection data but don't want to have to input the whole name only first and last name. for example Theresa Carey.
How can i build it into my code to exclude the . @ticketmaster.co.uk?
Let me know if this makes any sense and if not i am happy to send a file across.
Regards
Theresa
RE: strName
Hi Theresa, thanks for your query. Try this out:
***
strname = "theresa.carey@ticketmaster.co.uk"
MsgBox Left(strname, Len(strname) - 19)
***
Hope this helps,
Anthony