If your text string is really what you showed us, then you don't need to
parse anything... simply replace the @ symbol in the address with an = sign
and then concatenate the fixed text around it...

"

--
Rick (MVP - Excel)


"ssylee" wrote in message
...
I'm trying to parse a list of email addresses into a different type of
string as follows:

For example, if I want to use to make a string
that says ",
how would you suggest me to separate the content that is before and
after the '@' character?

Thanks.