split by rows

  1. D

    Split rows into new rows

    How would I go about splitting the following sheet into the second sheet. Im looking for column d to contain a | if it does, split column by commas and create new rows. Input example title color day size owner ford blue mon 10 john chev red tue 8.1|8.2, 8.3 joe Output example title...
  2. TardisPilot

    Split Every N Rows From Worksheet Into New Worksheets Redux

    Hi All, First time posting here and I have a VBA question. I found a very old thread with code that created a new worksheet based on a user selected number of rows. Unfortunately, the new worksheets do not bring over the headers nor the cell formatting from the original document. I really need...

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