I need expertise on the following process.
Excel file with rows of multiple columns. I need to read the file
(a) assign respective columns to variables;
(b) extract part of a value from a column say column C where value is ‘joe-bank12345-zz’ and return length of 5 characters after bank, ie output = ‘12345’;
© then write the output ‘12345’ into another column;
I need to know the formula and also the sample, if it’s easy for you to assist. Thanks !