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.