Format of cell text in excel

Copper Contributor
I have a table with one column venue description for venues the text is all in one paragraph and i want to break it up evey 20 words at the next word after the nearest fullstop (so if fullstop is at 22 then after 22 words)

1 Reply

Hi @paul marsh

 

Show one example. Coz whether you want split that data in next column or another one?

 

Make it clear.