where does a character appear in a cell?

  • Thread starter Thread starter rjre
  • Start date Start date
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
 
Back
Top