To be different, try this:

=RIGHT(LEFT(A1,6))

OR,
To be conventional:

=MID(A1,6,1)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Sue" wrote in message
...
I would like to extract the 6th character (the 5) from the following example
of a string of characters e.g.B123456789.