+ Reply to Thread
Results 1 to 6 of 6

Parsing Data that does not work with Text to Columns

  1. 12-30-2013, 03:22 PM #1
    jfinkel18
    jfinkel18 is offline
    Registered User
    Join Date
    12-30-2013
    Location
    United States
    MS-Off Ver
    Mac 2011
    Posts
    3

    Parsing Data that does not work with Text to Columns

    I have data with the following structure. Each of the lines is in 1 cell

    1. Team Icyenda Brings The Party Vibe 16 243 total plays +14%
    2. K-See 14 - Representing New Hampshire 13 44 total plays -28%
    3. DJ Aneyxor, Heading Towards World Class 13 423 total plays 0%
    4. Creating That Fine Band Of Success 13 24 total plays +100%

    My goal is to split the data so that it looks like this (each comma represents a separate cell. Note that some of the titles have commas and some of the titles also have numbers in the,

    Team Icyenda Brings The Party Vibe, 16, 243, total plays +14%

    Any Help would be greatly appreciated.

    Thanks.

    Justin
    Reply With QuoteRegister To Reply
  2. 12-30-2013, 03:24 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Parsing Data that does not work with Text to Columns

    Hi and welcome to the forum

    Sometimes when you copy/paste data to here, it loses formatting and is hard to make out where 1 set of data ends and the next begins - this is 1 of those times

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 12-30-2013, 03:44 PM #3
    jfinkel18
    jfinkel18 is offline
    Registered User
    Join Date
    12-30-2013
    Location
    United States
    MS-Off Ver
    Mac 2011
    Posts
    3

    Re: Parsing Data that does not work with Text to Columns

    Thanks for the prompt response.

    Attached is a spreadsheet that articulates the before and after. I am trying to download statistics from Soundcloud and analyze them in Excel (if this information is at all useful).

    Thanks,

    Justin
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 12-30-2013, 04:59 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Parsing Data that does not work with Text to Columns

    See if the attached is what you want...

    the modified =LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$10000)))) is Courtesy of:*Ron Coderre
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 12-30-2013, 05:12 PM #5
    jfinkel18
    jfinkel18 is offline
    Registered User
    Join Date
    12-30-2013
    Location
    United States
    MS-Off Ver
    Mac 2011
    Posts
    3

    Re: Parsing Data that does not work with Text to Columns

    That works perfectly. Thanks so much.
    Reply With QuoteRegister To Reply
  6. 12-30-2013, 05:19 PM #6
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Parsing Data that does not work with Text to Columns

    Happy to help Note that is you have a numeric between the 11th char and the 1st of teh "real" values, the formula in E will not work out right, so you will need to increase the "10" in that part of the formula
    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)

Similar Threads

  1. Problems parsing data from text file to excel columns
    By combsrj in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-31-2013, 08:11 AM
  2. Parsing Data w/Paragraph Marks as separators - using Text to Columns
    By whitsonn in forum Excel General
    Replies: 0
    Last Post: 12-10-2011, 01:21 AM
  3. Parsing text to columns
    By basic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-02-2010, 01:46 PM
  4. Parsing Text from One Column, Ten Rows into One Row, Mulitple Columns
    By bullsfan80 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-12-2010, 03:24 PM
  5. How to stop text to columns automatically parsing
    By mystic342005 in forum Excel General
    Replies: 2
    Last Post: 02-21-2008, 09:49 PM

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