I have a column with 50 rows of data, each of which have several thousand characters of text in them.
Wrapping the text and extending the column size doesn't show all of the text, so I need to insert hard returns manually.

Is there any way for VBA to automatically insert these at the first 'space' it finds after 100 characters in the cell, then go onto the next cell once done?

Thanks

Mxx