Hi everyone, I have some information in a column of my spreadsheet. Each row con

Question

Hi everyone,

I have some information in a column of my spreadsheet. Each row contains a person's name and then after the name is their email address in brackets, i.e

firstname lastname (*** Email address is removed for privacy ***)

I wondered whether there is a way to break up the column so that tthe name is in 1 column and the email address, without the brackets, is in a second column.

It would save so much time if I could use a function or something as there are 368 rows in the spreadsheet.

If it's possible to do the above, I was hoping that I could sort the email address column in alphabetical order according to the domain name, so I would somehow have to tell excel to sort by the information after the @ sign. If that's possible, could someonbe also help out with that?

Really appreciate aany help.

Thanks!!!

Explanation / Answer

If I understand correctly you have data stored in a worksheet column with Name (email). You can separate the Name and Email with this formula placed in an adjacent column in the same row. =MID(A1,1,FIND("(",A1,1)-1) In another cell in the same row you can place this formula and it will bring in the email address. =REPLACE(A1,1,LEN(B1),"") Unforrtunately with these formulas the parenthesizes will still be there and AFAIK you would have to do a couple of more Replace formulas or Left and Right formulas to remove them. Hopefully someone more gifted with these type of Excel Text formulas than I, can show you a better way. With that said, if your ultimate goal is to just have a cell that you can sort the data based on the domain names of the emails you can change the first formula to: =MID(A1,1,FIND("@",A1,1)-1) and leave the second formula as is =REPLACE(A1,1,LEN(B1),"") and you have a data field that you can sort based on domain name. Hope this helps!!!!.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.