Finding specifically formatted variable within a string?

[Erik the Awful]

I have cells that typically end in 2 or 3 digits followed by a K, but on rare occasions they have text after the K. It is possible for a K to appear elsewhere in the cell. Is there a way to search for the pattern of ###K without macros? It is feasible to move the ##K to another adjacent cell, but that makes updating and reading the sheet more difficult, and I'm wanting to add the search to simplify the updating.

 

[Scott Huish]

Will this suffice?

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

 

[Erik the Awful]

Will this suffice?

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

I'm trying to add up the two (or three) digit numbers to the left of the K, but it is possible for there to be a K elsewhere I the cell. Unfortunately, the cells are formatted for presentation, not calculation.

 

[Scott Huish]

Can you provide a sample of both, if it's always a number before the K, and a K can be afterward, then a simple modification of my formula would isolate the number:
=LEFT(A1,FIND("K",A1)-1)+0

 

[Erik the Awful]

A cell will typically contain "1000-1400 Alpha12 50K". Sometimes it might be "1000-1300 Alpha41 55K CFG" or it could be "1030-1500 Kilo23 60K". I'm trying to add up the numbers before the Ks.