Extracting a character from a string of characters

[Guest]

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

 

[Don Guillett]

Have a look in HELP index for MID

 

[Guest]

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

=MID(a1,6,1)

 

[RagDyeR]

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!
=====================================================


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

 

[Pan]

=mid(The String,6,1)

 

[CLR]

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

 

[CLR]

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