Splitting cells by non-printable characters

[Simon1185]

Morning All,

I've had a quick look at past posts and there is plenty on splitting cells but I haven't been able to find anything to help me with the following:

I've pulled address details from a database which have populated into a single field with each line separated by 2 'square' characters. I need to split each line into a separate cell for a mail merge. I've seen these characters before and always assumed they represent a space or 'return' and I believe is an ASCII character?

If I select a cursor in the cell the lines drop as they should with 1 square character left at the end of each line and it stays this way when I leave the cell.

I've tried CLEAN & TRIM functions; the first removes the characters, the second doesn't recognise the character at all. The most promising seems the 'Text to Columns' function, setting it as a delimited string, but I don't seem to be able to enter this particular character as the delimiter under the 'other' option.

Any ideas?

Many thanks in advance,

Simon.