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?

Carson Penticuff

=RIGHT([ONE CELL]@row, LEN([ONE CELL]@row) - FIND("!", SUBSTITUTE([ONE CELL]@row, "_", "!", 3)))

Paul Newcome

Do you want to include the [square brackets] or no?

Carson Penticuff

=RIGHT([ONE CELL]@row, LEN([ONE CELL]@row) - FIND("!", SUBSTITUTE([ONE CELL]@row, "_", "!", 3)))

Keya Sult

https://community.smartsheet.com/discussion/comment/387008#Comment_387008

Hi @Paul Newcome, I don't want the square brackets included; just wanted to signify a column

Keya Sult

@Carson Penticuff That works perfectly!! Thank you so much!