Hello everyone, I have an excel file with ~15.000 rows that need to be cut(Cut means to get last 8 characters from each row). Currently, I’m using Substring method but that takes too much time(around 20 minutes). Is there any faster approach to solve this problem? Thanks in advance.

@bp777 - Here is the sample… [image] Read Range - and called my datatable as dt. Add Add DataColumn - [image] Invoke Code [image] dt.AsEnumerable().ToList().ForEach(Sub(row) row("substring") = Right(row("Org Value").ToString,8)) Write Range your output Here is my Output [image] …

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

Help Activities

Palaniyappan (Palaniyappan P ) September 13, 2021, 11:03am 2

Hope this thread would help you resolve this

Cheers @bp777

Topic		Replies	Views
Excel row by row Help activities	7	1519	July 11, 2019
Substring a column Without looping Help	14	5169	December 14, 2019
How to fetch last 2 digits of a row in an excel file? Help	9	5784	March 15, 2019
How to get the first 50 characters in a row from excel to do data entry Help	8	2283	May 11, 2019
Copying Substring of a column to another column? Help	5	1896	July 2, 2019

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

Related topics