Jerry

=TRIM(A1) will remove extra spaces.

Drag/copy as far as you need.

Unless they are html non-breaking spaces, for which there are other methods.

See David McRitchie's TrimAll code.

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

Gord Dibben Excel MVP

On Wed, 1 Dec 2004 16:49:06 -0800, JERRY8
wrote:

I exported data that automatically adds a space before the value in each
cell. How do I remove the space without clicking in each individual cell and
deleting the space?