Thread: Formula Please?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Formula Please?

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)