Hi

Hope someone can help with this, I've had a search and can't find an answer to this specific problem.

I've got an excel file and one of the columns in it contains loads of text. I need to split this text into separate columns each with a maximum character limit of 72 characters. I need to do this in order to upload it into another system (nothing to do with me but apparently that's what's needed!)

Is there any way to split text in this way, obviously text to columns doesn't do the trick in this case.

Any suggestions greatly appreciated!