This will allow you to change the 6th character to whatever value is in cell
F1............

=LEFT(A1,5)&F1&MID(A1,7,99)

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.