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?