Splitting Column into 2 Columns part 2

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.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top