How to extract the Row # digits from the Predecessor column
Here are some samples of what I have...
19FS 2d (I want to extract "19")
17SS (I want to extract "17")
762SS, 22FF (I want to extract "76" to one cell and "22" to another cell)
Any ideas?
Answers


I am sure there are more elegant ways, this is how I do it:
=VALUE(IF(CONTAINS("FS", [Primary Column]@row), MID([Primary Column]@row, 1, FIND("FS", [Primary Column]@row)  1)))
=VALUE(IF(CONTAINS("SS", [Primary Column]@row), MID([Primary Column]@row, 1, FIND("SS", [Primary Column]@row)  1)))
=VALUE(SUBSTITUTE(IF(CONTAINS("FF", [Primary Column]@row), MID([Primary Column]@row, FIND(", ", [Primary Column]@row) + 2, 100)), "FF", ""))

Thank you so much for this. There may be a way to combine all three structures and produce the results in one cell with the JOIN function in a column that is formatted as a Dropdown with multiple values per cell.
I'll give it a try and see if I can figure it out.
Will let you know how it goes.
Help Article Resources
Categories
Check out the Formula Handbook template!