....
BCBC wrote:

Someone has asked me to go through a very large Excel document and remove
all
of the square characters. I don't know how they got there, but they are
Arial
font and they appear at the end of some sentences after periods.
Sometimes
there is one, sometimes there are two. Is there some way I can do this
more
quickly? Any help is appreciated.

--

Dave Peterson


Try making a new column to the right of each existing column and use the
Substitute function to replace Char(10) with spaces (or whatever you want to
use.

Example: For column A, insert a column to the right of it and put:

SUBSTITUTE(A1,CHAR(10)," ")

Then use Copy & Paste Special to copy the values of column B into column A.


--
---------------------------------------------------------------
Michael J. Strickland
Quality Services
703-560-7380
---------------------------------------------------------------