eliminating returns in a field

[ckenney]

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

 

[Debra Dalgleish]

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

http://groups.google.com/groups?&[email protected]