Darth yoda
New Member
- Joined
- Feb 27, 2013
- Messages
- 35
Hi guys. I've been trying to split a column into 2 columns for about a week. I've played with a couple of macro's I've found on the net but have yet to meet with success.
I have 2 columns like this:
12 chevys
14 fords
8 toyotas
5 nissans
The data starts in row A7 for numbers and row B7 for cars both in sheet 2. I need to split it and paste to sheet 1 cell A19/B19 for the first column and E19/F19 for the second. It should end up like this:
12 Chevy 8 toyota
14 fords 5 nissans
Thanks again for the help.
I have 2 columns like this:
12 chevys
14 fords
8 toyotas
5 nissans
The data starts in row A7 for numbers and row B7 for cars both in sheet 2. I need to split it and paste to sheet 1 cell A19/B19 for the first column and E19/F19 for the second. It should end up like this:
12 Chevy 8 toyota
14 fords 5 nissans
Thanks again for the help.