1. 05-15-11 05:35 AM #1
    Formulawiz
    Formulawiz's Avatar Become A Pro!
    Join Date: 01-12-09
    Posts: 1,589
    Betpoints: 0

    Excel formula

    Have the following formula in Excel
    =SUBSTITUTE(D2,"at","")
    When I apply it to
    Seattle at
    Cincinnati at
    the at disappears which I want but I get the following names
    Setle
    Cincinni
    How do you remove the at after each team name
    It works fine for all other teams.
    Reply With Quote Reply With Quote
  2. 05-15-11 07:23 AM #2
    LT Profits
    LT Profits's Avatar Become A Pro!
    Join Date: 10-27-06
    Posts: 90,963
    Betpoints: 5179

    Try putting a space before the "at".

    So:

    =SUBSTITUTE(D2," at","")
    Reply With Quote Reply With Quote
  3. 05-15-11 07:29 AM #3
    runnershane14
    runnershane14's Avatar Become A Pro!
    Join Date: 07-23-07
    Posts: 803
    Betpoints: 84

    or you could do

    =LEFT(D2,LEN(D2)-3)
    Reply With Quote Reply With Quote
  4. 05-15-11 09:47 AM #4
    Formulawiz
    Formulawiz's Avatar Become A Pro!
    Join Date: 01-12-09
    Posts: 1,589
    Betpoints: 0

    Works Fine
    Thanks
    Last edited by Formulawiz; 05-15-11 at 09:53 AM.
    Reply With Quote Reply With Quote
Top
« Previous Thread | Handicapper Think Tank | Next Thread »