You use the word 'numeral' suggesting a single digit in each case.
But then you FIND K rather than using =LEFT(A1,1) to get the first 4.
So I assume we could have, for example, 15K (C56)
Try this
=LEFT(MID(A1,FIND("(",A1)+2,2),FIND(")",A1)-FIND("(",A1)-2)
By the way if you want the results to be numeric precede each formula
with -- (a pair of unitary negations)
--=LEFT(MID(A1,FIND("(",A1)+2,2),FIND(")",A1)-FIND("(",A1)-2)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"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