Apply TRIM to whole column

Check your cell references - do you have absolute references
in your 
formula?

Example  =TRIM($A$1) is absolute and would get results from
A1 only when 
copied down the column.

              =TRIM($A1) is relative with regard to rows,
and should work 
down the column accordingly.

Just a guess.

>From: Claudia <TotaTuaVERIZON.NET>
>Reply-To: MS Excel General Q & A List
<EXCEL-GPEACH.EASE.LSOFT.COM>
>To: EXCEL-GPEACH.EASE.LSOFT.COM
>Subject: Apply TRIM to whole column
>Date: Sun, 31 Dec 2006 10:38:33 -0800
>
>How do I apply TRIM to a whole column? When I click
paste special or copy
>down, formula only, I still get the value of the first
cell.
>
>Tota Tua
>Claudia
>
>--------------------------------------------------------
------------------
>The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
>international's LISTSERV(R) software.  For
subscription/signoff info
>and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
>http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

____________________________________________________________
_____
Type your favorite song.  Get a customized station.  Try MSN
Radio powered 
by Pandora. http://rad
io.msn.com/?icid=T002MSN03A07001

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G