I have an Excel cell with an address in, and each line of the address is
separated by a non-printing character. I need to replace it so that I can
use the 'text to columns' function to get each line of the address into
separate columns.

The find & replace function won't recognise the nonprinting character, and
the clean/trim/substitue formuale seems only to be capable of removing it.
Any ideas?