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.