Excel VBA truncate cells in a column
Posted on 2014-04-07
I need to truncate all the data in each cell in column I to just the first 20 characters (alpha & numeric) I was trying to use this but this example truncates the data in all columns. It doesn't look like it should, but it does.
Edit: I'm not trying to delete spaces, just make the max = the first 20 characters.
Dim rCell As Range
For Each rCell In Range("I1", Cells(Rows.Count, 1).End(xlUp))
rCell = Left(rCell, 20)