Hello,
I'm currently trying to extract multiple strings with the same phrases ( the serial #'s located in the example below) . I currently only have my formula set up to extract one serial # but I need to extract multiple if there are multiple serial #'s present in the cell. Formula and example below.
=TRIM(LEFT(SUBSTITUTE(MID(A2,B2,100),")",REPT(" ",100)),100)). A2 is column with statement that contains the phrases, B2 is the position of the first character of the phrase.
Example: Phosphorus (Serial ####-##) and Ammonia NH3 (Serial ####-##) (This is provided in lab handout)
There are some instances where I have up to 10 serial #'s. If you need any help understanding the question, I will try and clarify the best I can.
Thanks!
Bookmarks