=MID(A1,2,4) if you want it as text or =--MID(A1,2,4) if you want it as a
number.
--
David Biddulph

"Eric" wrote in message
...
I need to extract portions of cell contents (i.e. B109912345 - i need the
1099 out of this info) and prot it to the cell to the right (next column)