Split rows by bold text

Hello everyone,

I have an Excel sheet with 2 columns : Date and TextColumn

The TextColumn column contains in each cell text such as this :

Title1
TextLine1
TextLine2
Title2
TextLine3
TextLine4
....

I need to split each line as follows :
Each title (in bold and on a new line) and the text who follows should be placed in a new row, copying the date in each new row created.

Is there a solution for that?
Thank you in advance!

You can use UDFs to extract the Bold text and then maybe reorganize.

Formula:

Please Login or Register  to view this content.

Is every cell in that same format; one title, two text lines? If so, you could just use LEFT & MID to pull the text apart and then conditionally format the range to bolden every nth cell automatically.