I am reading data from an Excel file. One field contains a string in each row, if a certain substring(s) is present I want to populate another predefined but empty field with a 'Y' or 'N' otherwise. How can this be done? Below, if column A contains a 't' and no 'r' I want to output 'Y'.
Please sign in to leave a comment.