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

Have a look in HELP index for MID

--
Don Guillett
SalesAid Software

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

If its always the 6th character use MID
i.e. if B123456789 was in cell A1

=MID(a1,6,1)


--

_______________________
Naz,
London


"Sue" wrote:

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

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.

=mid(The String,6,1)


--
Pan
------------------------------------------------------------------------
Pan's Profile: http://www.excelforum.com/member.php...o&userid=28144
View this thread: http://www.excelforum.com/showthread...hreadid=480398

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.

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.