Excel formula

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Formulawiz
    Restricted User
    • 01-12-09
    • 1589

    #1
    Excel formula
    I have a pitchers name in a cell called Y. Carmona
    I would like to get rid of the period and get in another cell such as
    Y Carmona
    What is the excel formula
  • dirk93
    SBR Rookie
    • 10-17-09
    • 48

    #2
    Data -> Text to columns -> Delimited -> Other (place a period in the box) -> Finish

    Let's say that puts "Y" in A1 and "Carmona" in B1

    Then in C1 use =A1&B1

    If you are just using this for Y. Carmona, this will work (Y. Carmona is in A1): =LEFT(A1,1) & " " & RIGHT(A1,7)
    Comment
    • Peregrine Stoop
      SBR Wise Guy
      • 10-23-09
      • 869

      #3
      just thought about creating a school to make people Excel formula masters.... valuable skill

      One issues with the second way above is that it only works for a pitcher with exactly 7 letters in his last name. Better to use a middle function starting at spot 4 and going on long enough to get any last name.
      Comment
      • Emily_Haines
        SBR Posting Legend
        • 04-14-09
        • 15917

        #4
        =substitute(a1,".","")
        Comment
        • Formulawiz
          Restricted User
          • 01-12-09
          • 1589

          #5
          Originally posted by Emily_Haines
          =substitute(a1,".","")

          Thanks worked fine
          Comment
          • arwar
            SBR High Roller
            • 07-09-09
            • 208

            #6
            i don't know about Excel functionalities themselves and their relative ease of use, but a ton of data manipulation can be done on files (like .csv files) before import to Excel - simply by using the Edit--->Find/Replace functions in Notepad. for example in the other thread he wanted to get rid of the -R and -L on tbe pitchers.
            Comment
            SBR Contests
            Collapse
            Top-Rated US Sportsbooks
            Collapse
            Working...