Hi friends,
I am trying to clean up and data file and would like to automate the process to some extent to save on time. What I am looking to do in for excel to search any rows for all the data in columns C to J for values which are S(----), numbers in brackets. The numbers can be anywhere between 1 to 10 and the excel should ignore the number of digits inside the brackets. The trigger to find should be S(). I am also looking to search this even if its input as part of the same word/address. It should then cut and paste this data to column K. I have attached screenshot of the file for better understanding. Appreciate the help and guidance on this. Thanks!
DataFile.png