Excel Find Problem

[JB]

I have several users of Excel 2003 and myself who when
coping a cell and trying to find other instances of that
value in the workbook or sheet, we get the error
message "cannot find the data you're searching for" When
clicking the down arrow to view other previous searches a
square box appears which I assume is either line feed or
carriage return. I have seen other postings online
elsewhere on how to fix the problem one cell at a time,
but how can the extra characters be removed from an entire
spreadsheet or workbook all at once? Anyone have some VB
that will do this?

 

[JB]

The following code seems to work well, I saved in
personal.xls so it would be available to any open
spreadsheet

'***begin code
For Each Worksheet In ActiveWorkbook.Sheets
Worksheet.Activate
Columns.Replace What:=Chr(10), Replacement:=""
Columns.Replace What:=Chr(13), Replacement:=""
Next

End Sub
'***end code