How can I scan the text in one column, and put a key term into another column?
Hello all! This is my first post on this board so I apologize if it is not formatted correctly. I am in the process of coming up with a new script to analyze a 12 experiment stacked data set. I need to take some key phrases from our "Batch ID" column and organize them into other columns using a formula/script (preferably formula). So in this scenario I need the "B01" phrase to go into the Bioreact...