where does a character appear in a cell?

R

rjre

morning all....

Is there a function that allows me to calculate where in the cell a
specific character appears?

ie: i have a string of text "abcd!efghi" can i see where the "!" is by
number of characters from left or right?

thanks

richard
 
Top