Hi Kelly,

If your values contain only numbers then use the functions LEFT, RIGHT, MID,
e.g.

=LEFT(A1) if you want the first number as text
or
=--LEFT(A1) if you want the first number as number

=MID(A1,2,1) if you want the second number as text
or
=--MID(A1,2,1) if you want the second number as number

If your values contain both numbers and letters then try this ARRAY formula
(Ctrl+Shift+Enter):

=MID(A9,MATCH(TRUE,ISNUMBER(--MID(A9,ROW(INDIRECT("1:"&LEN(A9))),1)),0),1)

=--MID(A9,MATCH(TRUE,ISNUMBER(--MID(A9,ROW(INDIRECT("1:"&LEN(A9))),1)),0),1)


Regards,
KL



"Kelly O." wrote in message
...
I am trying to find a formula that will allow me to extract only the very
first number in a cell. For example, if I have the number 123456 in cell
A2,
I would like a formula in cell A1 that will give me only the value 1; if I
have the number 234567 in cell B2, I only want the value 2 in cell B2, and
so
on. Further, is it possible to capture more than the first number if I
need
more than that?

Thanks, Kelly