character lookup in excel

[gerg]

How can I determine the position of a certain character within a string in a
cell in ms Excel ?

 

[Mike H]

Hi,

=SEARCH("a",A1)

or if you want a case sensitive option

=FIND("a",A1)

Mike

 

[David Biddulph]

FIND