View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kendraa
 
Posts: n/a
Default delete series of letter in spreadsheet

Just copy that into one cell, cell A1?
All I get is a "0"
??

"Claude S" wrote:

Try this formula in a blank cell where "A1" is the cell containing the email
address. =RIGHT(A1,LEN(A1)-FIND("@",A1,1))
--
Claude S


"kendraa" wrote:

I have a large document that contains thousands of email addresses. I want
to delete the part that becomes before the "@" sign, inlcuding the "@" sign
across the whole spreadsheet. EG: becomes ecollege.com
only. How can I do that?