+ Reply to Thread
Results 1 to 3 of 3

Spliting Cells?

  1. 06-13-2008, 01:09 PM #1
    samhale
    samhale is offline
    Registered User
    Join Date
    06-13-2008
    Posts
    5

    Spliting Cells?

    I don't know if this is possible, but ideally I would C+P something of a website, so cell A1 looks like:
    " 17:55 Vegas Baby (IRE) 4-5 1st "
    I need for it to split for the time at the start to be B1, and for anything between that and the '(' to be B2.
    In this example B1 would be '17:55' and B2 would be ' Vegas Baby '
    The time would always be the same, so I guess I can just show the first 6 characters, but I don't know about after (the horses name)
    Any Help?

    Many Thanks,
    Sam.
    Last edited by samhale; 06-13-2008 at 01:22 PM.
    Reply With QuoteRegister To Reply
  2. 06-13-2008, 01:49 PM #2
    gurusanthanam
    gurusanthanam is offline
    Registered User
    Join Date
    05-17-2008
    Posts
    51

    Smile hi Sam

    this can be done with Find, left and mid formulae..


    Please check the file attached.

    Regards,
    guru
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 06-13-2008, 02:35 PM #3
    samhale
    samhale is offline
    Registered User
    Join Date
    06-13-2008
    Posts
    5
    Thank you very much for that excellent solution.

    It works amazingly well!

    Now I can import the horse and race times in 2 seconds instead of before having to type it all out;
    Many many thanks;

    Sam.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1