I have a column of about 500 names each of which has an email address
immediately to the right of the name, such as
Peter Pan

I need the <pancity2dot.com in a separate column.

Can you help?
--
Templar