I have problem extracting the information I need in a datatable. The “Result” field should be a 10 digits number starting with 380 or 455. The “Row” field should be the number after “-” or “/”. How can I do this? To create a running total and split? Or by regular expression?
I would be very grateful for any help.
testNum.xlsx (10.3 KB)