Try this macro:
Sub Replacehard()
Cells.Replace What:=Chr(10), Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
End Sub
Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com
"eames.librarian" wrote:
Hello,
I exported a bunch of Filemaker Pro records into Excel. Wherever there was a
hard return in Filemaker, there is now a little square box in the text,
showing where that hard return was. Is there a batch way I can get rid of all
of these little squares (i.e., all the hard returns)?
Thanks!