When using Alt + Enter, the linefeed is the 0010 character, not the 0013.

0013 is very hard to get rid of except through VBA or the CLEAN function.


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 11:56:13 -0700, Jeff Ingman
wrote:

One of the other posters here indicated that "013" is a carrige return. Now I
don't know why it is displaying in a cell as a symbol. I can create carrige
returns in cells by typing "Alt/Enter" and the symbol does not appear when I
click inside a cell.

Why does the symbol appear visibly sometimes but not others?

And why can't I loose it by typing "^013" in the replace box?

jeff

"RagDyer" wrote:

You're referring to *MS* documents in your post.

Since this is an XL group, this is what I do to find the code in XL sheets:

=Code(A1)

Will return the code for the *first* character in the cell A1, whether
visible or invisible.

If you know, or suspect a character (invisible) is elsewhere in the cell,
you can use something like this:

=CODE(MID(A1,2,1))
Where you're referencing the *second* character, or

=CODE(MID(A1,3,1))
Where you're referencing the *third* character,
And so on ... !


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jeff Ingman" wrote in message
...
I often find symbols in MS documents I'd like to remove or replace with
something else.

Is there a way to detect the underlying code of a symbol or special
character to use for "Search and Replace"?