Excel Question

[Templar]

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 <[email protected]>

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

Can you help?

 

[Lars-Åke Aspelin]

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 <[email protected]>

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

Can you help?

If the original data is in column A starting at row 1,
try the following formula in cell B1

=MID(A1,FIND("<",A1),999)

Copy down 500 rows.

Column B will now contain the part of the data that starts with a "<"

Hope this helps / Lars-Åke