check this site
http://office.microsoft.com/en-us/ex...561311033.aspx
On Sep 11, 8:21*pm, pecan wrote:
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?