TRIM

Tyre · Feb 19th, 2002, 07:22 AM

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

Barrie Davidson · Feb 19th, 2002, 07:32 AM

Quote:

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 · Feb 19th, 2002, 07:43 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 07:22 AM	#1
Tyre Board Regular Join Date: Feb 2002 Location: Regina, Canada Posts: 79	is there a way to apply TRIM to a whole column instead of cell by cell?

Feb 19th, 2002, 07:43 AM	#3
Tyre Board Regular Join Date: Feb 2002 Location: Regina, Canada Posts: 79	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.