I have imported a large amount of data to an Excel spreadsheet from
another (not a Microsoft application). It came to Excel originally as
a comma-separated file (*.csv).

In each cell, which contains a number of paragraphs of text, at the
end of each paragraph of text there are five equal signs following by
a little hollow square (which pastes as a solid circle here).=====•
•
And in between each paragraph there is another square. Like this
=====•
•
And this.=====•
•
And so on.=====•
•
1. I want to get rid of these
2. When I try to do a search and replace
a. I cannot copy and paste the square into the SEARCH AND
REPLACE dialogue box;
b. When I try to replace the five equal signs (=====), I get
the error message "The formula is too long".

Any ideas?

Thanks.

paddymichelle