Hi All,
I have a cell that contains a number of nodes that are delimited by pipes (|). There are not a fixed number of nodes in the cell.
I need a formula to return the value between the last 2 pipes.
Example:
one|two|three|four|five Return: four
one|two|three|four Return: three
one|two|three Return: two
Any help with this would be greatly appreciated.
Eric
I have a cell that contains a number of nodes that are delimited by pipes (|). There are not a fixed number of nodes in the cell.
I need a formula to return the value between the last 2 pipes.
Example:
one|two|three|four|five Return: four
one|two|three|four Return: three
one|two|three Return: two
Any help with this would be greatly appreciated.
Eric