I have a data in column "L" if type general that ppoulates with long strings...basically a paragraph in each cell. How do i truncate each cell so that it limits it to 2048 characters, starting from row 2 to the end of the column with data......anything passed 2048 would jsut cutt off...
Dim LastRow As Long
Dim rngNew As Range
LastRow = Cells(Rows.Count, 12).End(xlUp).Row
Set rngNew = Range(Cells(1, 3), Cells(LastRow, 3))
rngNew.FormulaR1C1 = "=LEFT(RC,2048)"
rngNew.Formula = rngNew.Value
Set rngNew = Nothing
you may find this quicker if you have lots to do see what you think