Page 1 of 9 123 ... LastLast
Results 1 to 10 of 82

Thread: Excel Sorcerers!

  1. #1
    Senior Member
    Join Date
    Jan 2014
    Posts
    10,171

    Excel Sorcerers!

    I have run out of talent in Excel.

    I have one column that has multiple elements separated by a slash, eg one/three/five/seven and I need to break that single column into multiple columns BUT I need that breakup to happen in a specific way - one needs to go into column 1, three into column 3, etc. Like:

    Original A B C D E F G H
    1/3/5/7 1 3 5 7
    2/4/6/8 2 4 6 8

    Any ideas?

  2. #2
    Corvette Enthusiast Kchrpm's Avatar
    Join Date
    Jan 2014
    Location
    Cincinnati, OH
    Posts
    8,697
    Hmm...
    What are the elements? How do you know what columns they need to go in to?

  3. #3
    Corvette Enthusiast Kchrpm's Avatar
    Join Date
    Jan 2014
    Location
    Cincinnati, OH
    Posts
    8,697
    The solution I have so far is sloppy, inflexible, I don't like it, but it works, technically.

    Why not text to columns? Makes it a lot easier once they're already separated.

  4. #4
    Corvette Enthusiast Kchrpm's Avatar
    Join Date
    Jan 2014
    Location
    Cincinnati, OH
    Posts
    8,697
    Ok, came up with a better solution, using formulas to change each of the symbols into different characters so the data between them can be easily extracted.

  5. #5
    Corvette Enthusiast Kchrpm's Avatar
    Join Date
    Jan 2014
    Location
    Cincinnati, OH
    Posts
    8,697

  6. #6
    Junior Member
    Join Date
    Jan 2014
    Posts
    11

  7. #7
    Junior Member
    Join Date
    Jan 2014
    Posts
    11
    tsg: are there any other possible combinations in your first column? like 2/5/3/6? and can there be cells with different numbers of digits?

    OR DID KEITH RECOVER THE SIX DEMON BAG AND YOU'RE ALL SET?

  8. #8
    Senior Member
    Join Date
    Jan 2014
    Posts
    10,171
    There are ten possible original values, and each of those ten possible values go into one of ten specific columns... value 1 is always column 1, value 2 is always 2, etc. I think that sorcery works perfectly. I was looking for a way to move values from original to destination, but I see how sucking values works better. I'll try that tomorrow! Thanks!

  9. #9
    Senior Member
    Join Date
    Jan 2014
    Posts
    10,171
    Minor tweaks, but that totally worked. Thanks!!

  10. #10
    Corvette Enthusiast Kchrpm's Avatar
    Join Date
    Jan 2014
    Location
    Cincinnati, OH
    Posts
    8,697
    Get that weak shit off my track

Posting Permissions

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