If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
eliminating returns in a field
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 |
Thread Tools | |
Display Modes | |
|
|