eliminating returns in a field

A have a rather large spreadsheet and in a number of cells
there are "returns" in the cell. Is there a way to
eliminate these "returns"?

"returns" = someone hit enter in a field while in Access
and now I am exporting the info to excel, do some clean
up, and then change to a text file. This is when I see
the problems when someone hit the return key.

Anyone able to help?

Thanks

Dave Peterson posted the following macro that you can use to clean up
the worksheet:

http://groups.google.com/groups?&thr...BB4E%40msn.com

ckenney wrote:
A have a rather large spreadsheet and in a number of cells
there are "returns" in the cell. Is there a way to
eliminate these "returns"?

"returns" = someone hit enter in a field while in Access
and now I am exporting the info to excel, do some clean
up, and then change to a text file. This is when I see
the problems when someone hit the return key.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html