I have a list of strings in a column and am trying to separate out a piece of each of those strings.
However, each string has a different number of characters and words with the piece that I'm trying to identify buried in the middle.
For example, "Fruit Mix 6/20z", is one of these strings. I am trying to pull the "6" into a new column and the "20" into another new column.
"Brussel Sprt Seasnd 12/10z TJs" is another example. In this instance I want to pull the "12" into a column and the "10" into another.
In all these strings, the numbers I want to pull out are always immediately before a "/" and immediately after.
Thanks for all your help!
Bookmarks