thanks that worked
what I was doing was trying to sort data from 2 sheets (combined into one)
1 sheet (I think was converted from Lotus123), and tho the data looked the same, it acted like there were preceedign spaces in the one column of data. I know TRIM applied to the data in the cell will eliminate the problem, but I had 1000 cells to trim.