Hi,

I am going to import some textfields from excel into an ERP system. But the erpsystem can only take 50 characters per line, but the text is often much more than this. So therefore i have to split them up, and add a number to the line.
For instance.

The text is: "Hey this is a testtext"

And i have to split the text into:

1 Hey this is
2 A testtext

And i am receiving maybe 1000 textlines that has to be spllitted, any ideas?

Thanks in advance