-
January 7th, 2014, 04:00 PM
#1
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?
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