Extracting a character from a string of characters

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)

Have a look in HELP index for MID

--
Don Guillett
SalesAid Software
[email protected]
"Sue" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
I would like to extract the 6th character (the 5) from the following example
of a string of characters e.g.B123456789.

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> I would like to extract the 6th character (the 5) from the following
example
> of a string of characters e.g.B123456789.
>
>