Finding the 9th character of a string in Excel

[t16turbo]

HI all,
how can I achieve this?
in SQL I have used SUBSTR([value], 9,1) etc
how can I do this in an Excel formula?

thanks,

 

[dhulbert]

use the mid function =mid(string,start,length)

 

[SkipVought]

Hi,
[tt]
=MID(A1,9,1)
[/tt]
use MID like SUBSTR.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[t16turbo]

thanks guys, thats great