-
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?
-
Hmm...
What are the elements? How do you know what columns they need to go in to?
-
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.
-
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.
-
-
-
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?
-
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!
-
Minor tweaks, but that totally worked. Thanks!!
-