use TRIM function. e.g. if your data is in column A, you could put formula
in b1:
=TRIM(A1) and copy down the length of your data. removes both leading and
trailing spaces.

"dstiefe" wrote:

I have a colum of data that has spaced before the text...the number of spaces
varies per cell..

how do i eliminate the spaces within each cell?

Thank you