Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Parsing Data (Excel 2003 SP3)

    I have a column of data in a spreadsheet that is comprised of numbers and text and symbols the format is "xxx77xxx - xxxxxxxxxxxx". The length of the column is variable. WHat I am needing is to be able to extract all data to the right (or following) of " - ", the "space,hyphen,space" is the only characters unique to each record.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Parsing Data (Excel 2003 SP3)

    Let's say that your data are in A2 and down (A1 is a column header).
    Enter the following formula in B2:
    <code>
    =MID(A2,FIND(" - ",A2)+3,100)
    </code>
    Then fill down as far as needed. The number 100 in the formula is merely a number larger than the longest text string you expect to encounter; if you're sure that the xxxxxxxxxxxx part at the end will never be more than 20 characters long, you can use 20 instead of 100.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Parsing Data (Excel 2003 SP3)

    Thanks Hans, I was doing this but was using too small of number on the field length - thanks again

Posting Permissions

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