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?

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 wrote:

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?

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?



On Jan 19, 4:06 pm, "Pete_UK" wrote:
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 wrote:
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?- Hide quoted text -- Show quoted text -

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

jimmc wrote:

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?



On Jan 19, 4:06 pm, "Pete_UK" wrote:
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 wrote:
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?- Hide quoted text -- Show quoted text -