Dear experts,

is it possible to find one ore more characters in one cell and then give the character(s) next to it in another cell?
example:

a cell contains the following string:

110CageB.R52B2/PP1/port8
110CageB.R52B2/PP2/port8

in the new cells I want to find PP and give the result which is 1 for the first line and 2 for the second line.

So I want to display the character next to PP in a new cell.


Thanks in advance!!!

Robinski