Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    May 2001
    Location
    Berkeley, California, USA
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    copy a partial string (97 SR2)

    I have a spreadsheet with a long list of email addresses in column C. What I would like to is to copy the characters between the "@" and the ".com" in each cell in column C into the adjoining cell in column D. Is there a formula I can enter into column D to do that.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: copy a partial string (97 SR2)

    <pre>=SUBSTITUTE(MID(C1,FIND("@",C1)+1,LEN(C1)),". com","")</pre>


    copy it down the column

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •