find a replace character question

[jimmc]

Is it possible to do a Find and Replace for the square character (which
represents the Enter key) that comes from an imported .csv file?

 

[Pete_UK]

If you mean the line-feed character, that has a code of 10. In the
Search For box you can enter this by holding down the ALT key and
typing 010 on the numeric keypad - you might like to replace it with a
<space> rather than <nothing>.

Note, though, that other non-printable characters can appear like small
squares.

Hope this helps.

Pete

 

[jimmc]

Thanks for the input. The line-feed character 10 doesn't seem to be
what I'm looking for. It's actually a hollow square character that
reflects a line-feed and tab. Any thoughts?

 

[Pete_UK]

Imagine you have some data in A1, and the offending character is in
position 10 of the string. This formula in B1 will give you the code of
the character:

=CODE(MID(A1,10,1))

Adjust the cell reference and the "10" to suit where your character is.

Then you could enter this code with ALT in the Find/Replace dialogue,
as described earlier.

Hope this helps.

Pete