It's a bit surprising, but I couldn't find any macro doing this.
I would like to wrap text inside cells with a hard return (like typing alt-Enter) after 40 characters (or less if the 40th falls in the middle of a word) using Excel 2003.
Starting cells (no hard returns)
Lorem ipsum dolor sit...