Replace nonprinting character
 

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?

Replace nonprinting character
 

Try CTRL + j if the character is a linefeed 0010


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 08:21:02 -0700, 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?

Replace nonprinting character
 

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?