I have and excel sheet that was a contact list apparently exported wrong and has the names and addresses all together in each cell in about 350 rows in column A, they are all in this format
john doe email address here
for some reason the email address in brackets won't show up here but each email address is in <> brackets
I need to get the name in one column and the email address without the <> brackets into another, any ideas?
john doe email address here
for some reason the email address in brackets won't show up here but each email address is in <> brackets
I need to get the name in one column and the email address without the <> brackets into another, any ideas?
Last edited: