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

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?