The following data is in cells A1,A2.

16K (C7)
7K (C4)

I need to extract 16 and 7 into different cells.

=LEFT(A1,2) handles the 16.
=LEFT(A2) handles the 7.

What is the formula for handling single and double digits please?

Thanks.