where does a character appear in a cell?

[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

 

[rjre]

WHAT A FOOL!

I have it. a typo in my search wasn't helping!

richard

 

[Neil Perry]

So how do you do it then?

WHAT A FOOL!

I have it. a typo in my search wasn't helping!

richard

 

[rjre]

Cell A1= "abcd!efghi"

=FIND("!",A1)

Rich

So how do you do it then?






- Show quoted text -

 

[Neil Perry]

Thank you.

Cell A1= "abcd!efghi"

=FIND("!",A1)

Rich