Help with extracting values from one cell to the other
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!