find a replace character question

  • Thread starter Thread starter jimmc
  • Start date Start date
J

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?
 
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
 
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?
 
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
 
Back
Top