If they're *always* single digits,

Extract the first 4 with:
=Left(A1)

And the second 4 with:
=Left(Right(A1,2))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Saxman" wrote in message
...
I have the following data in cell A1.

4K (C4)

I need to extract both numerals.

By placing the following formula in another cell extracts the first 4.

=LEFT(A1,FIND("K",A1,1)-1)

What is the formula for removing (C) and placing the 2nd 4 in another cell?

TIA