How to extract the Row # digits from the Predecessor column

Berto D

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?

Neil Watson

Neil Watson

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", ""))

Berto D

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.