What could be more efficient way to Substring ~15.000 rows in excel?

[prasath17 (Guru)]

@bp777 - To get last 8 you can use Right Function …see the example below…

Convert excel column to 2 decimal places

@Yudhisteer_Chintaram1 - Ok, please try like this… [image] Invoke Code: dt.AsEnumerable().ToList().ForEach(Sub(row) row("NW Elasthane 2DP")=Math.round(cdbl(row("NW Elasthane")),2).ToString("N2")) OR (if you want to write the output in Number format use the below…tested and working) dt.AsEnumerable().ToList().ForEach(Sub(row) row("NW Elasthane 2DP")=Cdbl(Math.round(cdbl(row("NW Elasthane")),2).ToString("N2"))) My Output [image] you can use write range and right the output to a new sheet …

and use this below code in the invoke code…

dt.AsEnumerable().ToList().ForEach(Sub(row) row("NewColumnName")=Right(row("ExistingColumnName").ToString,8))