Results 1 to 5 of 5

Thread: Data Deletion

  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hey folks!

    I have a situation where I had to import a selection list of data (from HTML). It is all formatted as follows:

    the second set of 0000 will be alpha and or numeric. I need to delete everything in the string after the quote, including the quote. All of the data after the quote is structured the same.




    0000">0000 - xyz</OPTION>

    Any Ideas?

    thanks,
    Brad

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    This will return everything up to the "
    =LEFT(A1,FIND("""",A1)-1)

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ok, that works good. Now, how about the other direction?

    I have another column where I need to see only the info after the "> I have already stripped the </OPTION>.



    0000">0000 - xyz</OPTION>


    I played a little with the first method, but am not hitting the correct combination.

    Thanks,
    Brad

  4. #4
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    This will return everything after the first > =mid(A1,find(">",A1),99).

    extra "(" removed - sorry Brad.

  5. #5
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Kept getting an error with the formula. Discovered the extra (. Removed and works great


    Thanks,
    Brad

Posting Permissions

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