TRIM

[Tyre]

is there a way to apply TRIM to a whole column instead of cell by cell?

 

[Barrie Davidson]

On 2002-02-19 06:22, Tyre wrote:
is there a way to apply TRIM to a whole column instead of cell by cell?

What are you trying to do? How about using Data|TextToColumns and specifying Fixed Length for you data type? You could then trim off what you want.

 

[Tyre]

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.