excel - Stripping charaters out of email address to extract url -

excel - Stripping charaters out of email address to extract url -

i need take column of emails addresses , strip out @ , before it, , add together "www." in order list of web addresses. found formula: =right(c6,len(c6)-find("@",c6)) need url , form each email , homecoming results every email address , re-create column

if have email address in cell a1, set in cell b1

=concatenate("www.", right(a1,len(a1)-find("@",a1)))

then drag formula downwards column until reach bottom row.

excel email url