Try this more conventional way with a single function:
=MID(A1,3,6)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RagDyer" wrote in message
...
If the original data is always the same length, and the data to be
returned is always in the same location within that data, try this:
=LEFT(RIGHT(A1,8),6)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Sharon R" <Sharon wrote in message
...
I need a formula to copy the middle digits from one cell to another. i.e.
132sk215zb from Cell A1 and transfer only the 2sk215 into Cell D1. Can
anyone help?