Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Jul 2003
    Location
    Notre Dame, Indiana, USA
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    breaking cell data down to smaller parts (Excel 2003)

    I'm not even sure how to explain what I want to do, and I have no idea if it's possible, so here goes:

    I have a spreadsheet that contains records of preprint inserts that are inserted into our daily newspaper. The underlying data comes from our billing system, which unfortunately, doesn't give us separate fields for 'number of pages', 'number of inserts', 'purchase order number', and other descriptive info. Our way of dealing with that is to use a 'note' field to key in data that looks like this:

    po#304-T/4 p tab/32,000

    As you can see, we've mushed the po#, number of pages and quantity of inserts into one data glop.

    Is there some way that I can separate that data into three cells-- in other words, break down the information so that it can be used in a pivot table? Other than re-keying everything, that is...

    Any help or guidance will be appreciated.

    Sherry Stuck
    Truth Publishing
    Elkhart, Indiana

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

    Re: breaking cell data down to smaller parts (Excel 2003)

    It might well be possible, but can you tell us exactly how you would the example to be broken down?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: breaking cell data down to smaller parts (Excel 2003)

    Is the data you want in each column as follows:

    po#304-T | 4 p tab | 32,000

    In other words, is what you need separated by the / character?

    If so, use Data>Text to Columns and choose delimited with the character of / as your delimiter in the "Other" box.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: breaking cell data down to smaller parts (Excel 2003)

    The answer to your question is almost certainly yes. However, we would need to see what the data currently looks like and what you want it to look like. Could upload a sample workbook that shows what it currently looks like (sanatized to disguise any confidential information), and then either show a separate worksheet of what it should look like, or describe in detail what you want it to look like?
    Legare Coleman

  5. #5
    Lounger
    Join Date
    Jul 2003
    Location
    Notre Dame, Indiana, USA
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: breaking cell data down to smaller parts (Excel 2003)

    Actually, I stumbled on the Data-->Text to Columns feature, and I think it will do the trick. However, I need to get my data coordinators to use a more uniform standard of entry.

    Thanks for your help.
    srs

  6. #6
    Lounger
    Join Date
    Jul 2003
    Location
    Notre Dame, Indiana, USA
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: breaking cell data down to smaller parts (Excel 2003)

    I actually stumbled on this just before I read your post. You're right, this feature can be very useful.

    Thanks for your help,
    srs

  7. #7
    Lounger
    Join Date
    Jul 2003
    Location
    Notre Dame, Indiana, USA
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: breaking cell data down to smaller parts (Excel 2003)

    Thanks, but I've found an answer that I think will work.

    srs

Posting Permissions

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