Appreciate all the help.

I tried the editreplace as it seemed to be the easiest solution and put a
space in the Find What field and nothing in the Replace field. That did not
work. It only worked for the few fields in which there was no character
string and just a space.

Will proceed to try the other suggestions.

================================================== ========

"Peo Sjoblom" wrote:

Put this macro in your personal.xls and then select the data and run the
macro

http://www.mvps.org/dmcritchie/excel/join.htm#trimall


if indeed the only spaces are at the end and nowhere else where they might
be needed you could also do an editreplace and replace space with nothing
(don't put anything in the replace box)

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"FRS" wrote in message
...
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.

Am I doing something wrong with the editreplace option?
=============================================

"FRS" wrote:

Appreciate all the help.

I tried the editreplace as it seemed to be the easiest solution and put a
space in the Find What field and nothing in the Replace field. That did not
work. It only worked for the few fields in which there was no character
string and just a space.

Will proceed to try the other suggestions.

================================================== ========

"Peo Sjoblom" wrote:

Put this macro in your personal.xls and then select the data and run the
macro

http://www.mvps.org/dmcritchie/excel/join.htm#trimall


if indeed the only spaces are at the end and nowhere else where they might
be needed you could also do an editreplace and replace space with nothing
(don't put anything in the replace box)

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"FRS" wrote in message
...
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.

FRS -

Am I doing something wrong with the editreplace option? <

Perhaps the "spaces" are really non-breaking spaces.

If so, in the "Find and Replace" dialog box, in the "Find what:" edit box,
hold down the Alt key and on the numeric keypad type 0160, and leave the
"Replace with:" edit box blank.

- Mike
www.mikemiddleton.com