Split text into length restricted columns by whole words

  • Hi,


    I need to split a long text entry to 2 columns which are limited to 30 characters each + any remaining text will be placed in 3rd column.

    The text needs to be split by whole words (so the split will not be done mid-word)


    See attached for reference

    - Column A shows the original entry

    - Column B needs to have first max 30 characters, but split by whole words

    - Column C needs to have next max 30 characters, but split by whole words

    - Columnd D will have all remaining characters


    Any smart ways to get it automated?


    ozgrid.com/forum/core/index.php?attachment/1226348/

  • Your attachment shows "Page not found" error when I try to download it.


    Does your data start in A2 and A1 is a header?

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Try the attached sample file (it uses Row 1 as header row with data starting in A2). Click the button


    Code assigned to the button is

    Files

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Edited 2 times, last by KjBox ().