Left Worksheet Function

  • Thread starter Thread starter matt
  • Start date Start date
M

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.
 
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
 
Back
Top