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

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,214,975
Messages
6,122,537
Members
449,088
Latest member
RandomExceller01

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