I am pasting data into a cell but want to limit it to a specific length. Is
there a function that will limit the text to the length required and carry
the remaining text onto the next row? Data validation does not work, it will
give me a warning but wont automatically cut the remaing text onto the next
row.

For example, copied text is 30 characters long. When i paste it into the
cell (which i want to limit to 20 characters long) it will automatically fill
one cell and paste remaining text into cell below.

Any help would be much appreciated