I tried this solution and ran the TRIM function from Sheet1 on to Sheet 2.
Did the copy and paste special as values. The sheet2 fields still show the
space at the end of the character strings.
================================================== ==

"Kevin B" wrote:

The following suggestion assumes that the data is in Sheet 1, and starts at A1.

In Sheet 2, cell A1 insert the following formula:

=TRIM(Sheet1!A1)

Copy the formula down column A, as far down as the last row of data in Sheet
1. Then copy all of column A in Sheet 2 across as many columns as needed to
reference the entire data set in Sheet 1.

While still in sheet 2, press Ctrl + Shift + * to select the entire regions.
Copy the selected cells and then paste special as Values. You can then use
sheet 2 for your csv file source.
--
Kevin Backmann


"FRS" wrote:

I have spreadsheets with tens of thousands of fields containing data. All of
the data consists of a string of characters followed by a space. In the end
I need to save the spreadsheet in a .csv format, WITHOUT the space in each
field.

Can anyone suggest a quick way to do this? Your help is appreciated.