Removing Unwanted Characters

[rsomist]

I have a column with over 1200 rows of email address in this format:

Smith, Ross <ross.smith@abcd.com>

In each of the 1200+ rows, I am needing to remove everything but what is inside of the brackets, so I would want that cell to say:

ross.smith@abcd.com

What is the best way to remove the Smith,Ross and the <> in all cells without manually doing it?

Thank You.

 

[vletm]

rsomist
One possible ...
1) Select that column
2) 1st Replace All

3) 2nd Replace All

 

[S. Das]

Do you need something like this...

 

[S. Das]

rsomist
One possible ...
1) Select that column
2) 1st Replace All
View attachment 49200
3) 2nd Replace All
View attachment 49201

You are so smart....

 

[GraH - Guido]

Just for spreading the word on possibilities with Power Query (different approaches possible, but here is just one when data is loaded in PQ):

1. it would look like this
   
2. the click on Split column by delimiter and confirm
   
   Data will look like this
   
   
3. Click Transform -> Replace Values
   
   Data looks like this
   
4. Give the headers a proper name and load to excel

 

[GraH - Guido]

Continued:
Data will finally look like this


And if you add data to the original data, the query can be refreshed and the same transformation steps are applied.

 

[shrivallabha]

Just to add to multiple approaches being posted, here's one formula based:
=SUBSTITUTE(MID(A2,FIND("<",A2,1)+1,LEN(A2)),">","")