XCL Formula

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Formulawiz
    Restricted User
    • 01-12-09
    • 1589
    #1
    XCL Formula
    I have the following
    Saturday, 4/23/2011 (1:05 PM)
    What I would like to do is capture the 4/23/2011 only
    What is the formula
    Thanks
    Tags: None
    • mike1234
      SBR Sharp
      • 09-06-07
      • 457
      #2
      =trim(mid(b2,find(",",b2)+1,11))

      b2 is the cell where your text is
        Comment
        Previous template Next
        SBR Contests
        Collapse
        Contests Home
        Leaderboards
        Top-Rated US Sportsbooks
        Collapse
        Working...