Replace nonprinting character

[pecan]

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?

 

[Gord Dibben]

Try CTRL + j if the character is a linefeed 0010


Gord Dibben MS Excel MVP

 

[muddan madhu]

check this site

http://office.microsoft.com/en-us/excel/HP030561311033.aspx