Help with extracting values from one cell to the other

Keya Sult
ββ
Hello, I am trying to extract a value from one cell to another cell. E.g. I have a column that goes by a specific sequence:" ["A"]_["B"]_["C"]_[ID No.]". I am trying to extract the [ID] portion (the string after the 3rd '_'). How may I be able to do this?
Best Answer
-
=RIGHT([ONE CELL]@row, LEN([ONE CELL]@row) - FIND("!", SUBSTITUTE([ONE CELL]@row, "_", "!", 3)))
Answers
-
-
=RIGHT([ONE CELL]@row, LEN([ONE CELL]@row) - FIND("!", SUBSTITUTE([ONE CELL]@row, "_", "!", 3)))
-
Hi @Paul Newcome, I don't want the square brackets included; just wanted to signify a column
-
@Carson Penticuff That works perfectly!! Thank you so much!