Splitting paragraphs in cells into several cells

mthwi · #1 01-17-2018, 05:47 AM

Hello, everyone,
i have uploaded the following table.
In worksheet 'Before' is the before-state (1. Image below)
See document Before.png.

In the worksheet 'After' is the after-state (2. Image blow)
See document After.png.

I also attached an excel file.

The cells containing texts with paragraphs are to be distributed on cells.

It is important that the number of columns and rows can vary.
This is just a small example.

I am looking forward to a solution. VBA would be great.

Thanks and greetings.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Splitting Cells in a Very Large Table	Paulvana	Word	4	01-06-2017 01:52 PM
Linking cells: can sub-cells move with their master-cell when sorting?	kw01	Excel	1	06-30-2015 05:02 PM
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM
Preventing cells from splitting into two pages	Jaymond Flurrie	Word VBA	1	05-11-2011 06:54 PM
Paragraphs vanishing in multi line cells	teknetia	Word Tables	0	08-02-2009 10:50 PM