Results 1 to 7 of 7

Extract data from a string - Varying length, between spaces

Threaded View

  1. #1
    Registered User
    Join Date
    09-06-2009
    Location
    Sussex, England
    MS-Off Ver
    Excel 2003 / Pocket Excel
    Posts
    6

    Angry Extract data from a string - Varying length, between spaces

    Hi,

    I have a string (as below - Call them A1:A4) which I would like to seperate into 4 columns (Call them B1:E4).

    I have successfully seperated the first part using MID (It's always 5 digits) but the second part has a varing length which then impacts on the third and fourth parts of the string.... Any ideas?

    87261 WIMBLEDON 10:08 10:10
    87169 NEWMALDEN PASS 10:13
    87171 SURBITON PASS 10:15
    87177 HMPTNCTJN PASS 10:16

    To add to this I am using the POCKET PC version of Excel which does not have all functions so at the moment I am limited to which functions I can use (Can you add functions to the PPC?).

    As you will see one thing common to the above strings is seperation by spaces.

    Thanks for any help. L.
    Last edited by Lee.shop; 09-11-2009 at 04:55 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1