IN addition to the formula answers given, you can also do this by using the
data TextToColumns feature........and set the column breakes where you
wish, then, if desired, you can later concatenate the string back together
without the old 6th character.......or change it if desired.

Vaya con Dios,
Chuck, CABGx3


"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.