[Urgent] Cut sentence at 40 char w/o distorting words

[dotchin]

Hello,


I need urgent help here and thank you for viewing and probably assist me in my Excel VBA problem.


Basically I have a database of sentences within the same cell that:
1)needs to be cut with max of 40 characters (without distorting the words on the 40th character)
2)Slot them back into the next few rows depending on how many characters (most no. of char I have up till now is 120 within the same cell)
3) rename the line number to reflect the latest changes
4) Re-do the same steps for all the lines and reflect the correct Process no. and Line no.


All these are shown below:


Before:

After:

Can someone create the Excel VBA code to automate these changes?

Thank you so much for your help!

 

[shg]

Also posted at [Urgent] Cut a sentence with max 40 char