DonkeyOte,
Why doesn't this EVALUATE() construct work?
![]()
Sub TruncateSelection() 'Select a range and then run the macro to truncate values without looping Dim Cell As Range With Selection.Cells .Value = Evaluate("IF(ROW(1:" & Selection.Cells.Count & "),LEFT(" & .Address & ", 12)") End With End Sub
Bookmarks