Relative Content

Tag Archive for excelvbasplitformatting

Is there a way to split a cell after two paragraphs; merge into new row

I have a spreadsheet full of data. In column “H” I have cells upon cells of between 3-7 paragraphs. Ideally I would like to split the cell into 2 paragraph max length cells and merge the remaining paragraphs down with that same rule. I have working VBA that will do this every paragraph. End goal is to instead do this every “x” paragraphs (ideally “2” paragraphs) for cells that contain lots of text. Thanks for any pointers!