Thread: Formula Please?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Formula Please?

find )
--
Don Guillett
SalesAid Software

"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


Reply With QuoteReply With Quote