Clearly Bob meant to type =MID(A1,FIND("C",A1)+1,1)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Saxman" wrote in message
...
Bob Phillips wrote:
If always that format
=MID(A1,FIND("C",A")+1,1)
Excel corrects this to
=MID(A1,FIND("C","A")+1,1)