How can I apply the Left Worksheet function to an entire
column. (i.e: truncate entire A: column). Any help is
much appreciated as always. thanks, matt.

=LEFT(A:A,<n)
Array entered (Ctrl-Shift-Enter)

Jerry

matt wrote:

How can I apply the Left Worksheet function to an entire
column. (i.e: truncate entire A: column). Any help is
much appreciated as always. thanks, matt.

You posted in programming so I give you a macro solution

You need a loop like this.
It will remove 3 characters

For Each cell In Columns("A").SpecialCells(xlCellTypeConstants)
On Error Resume Next
cell.Value = Left(cell.Value, Len(cell.Value) - 3)
On Error GoTo 0
Next


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"matt" wrote in message ...
How can I apply the Left Worksheet function to an entire
column. (i.e: truncate entire A: column). Any help is
much appreciated as always. thanks, matt.