I was given a spreadsheet of clients emails. I need to copy the emails to paste them into another sheet. But the emails supplied are not usable. They came through as test'<test@one.com>;test2"<testt2@two.com>.
I need a formula that will return the values between <> and separate by a ;.
So: test'<test@one.com>;test2"<testt2@two.com> should read test@one.com; testt2@two.com
I have tried several formulas but can not get it to work.
Can anyone help me?
Eds
I need a formula that will return the values between <> and separate by a ;.
So: test'<test@one.com>;test2"<testt2@two.com> should read test@one.com; testt2@two.com
I have tried several formulas but can not get it to work.
Can anyone help me?
Eds