Another Formula Please?

S

Saxman

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.
 
D

Duke Carey

2 ways

=left(A1,len(a1)-1) - results in text

if it's always a "k"

=SUBSTITUTE(A1,"k","") - also results in text

If you want the result to be a number, do something like

=SUBSTITUTE(A1,"k","")*1
 
C

CLR

Another way would be to do Data > TextToColumns > and use K as the delimiter
and choosing not to import the data to the right...........the beauty of this
method is that it does not require a helper column.

Vaya con Dios,
Chuck, CABGx3
 
Top