Left Worksheet Function

[matt]

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.

 

[Jerry W. Lewis]

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

Jerry

 

[Ron de Bruin]

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