As previous mentioned, I want to remove certain text and numbers in cells and output it in new cells. I accept both method either use read write assign or just excel formulate in cells. Appreciate any solutions and guidance.
I encountered error as the cells inside text contain spaces.
book2.xlsx (8.8 KB)
Read range activity reads the excel data into a table
Use For-Each Row to iterate rows
2a. Assign currentRow(1) = currentRow(0).ToString.Split(" "c)(0)
2b. Assign currentRow(2) = currentRow(0).ToString.Split(" “c)(currentRow(0).ToString.Split(” "c).Length-2)
Outside For-each just use a write range and write the same table back to Excel into the same sheet
Hope this helps.
Actually Im scrapping this idea but really appreciate the helps
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.