Separating alphanumeric data

[Jimbo1970]

Hi, I have the following data in a cell:

"Business Services Manager $125-105K Complement your track record."

I need to strip out the 125 and the 105 numbers into two new cells.

Any ideas as to how to do it. I have 2000 cells to sort!

The first number I need is always after a '$" and is always between two and three digits in length.

The second number always has a 'k' after it and again is always between two and three digits long.

Any help much appreciated.

[NBVC]

Try:

=MID(A1,FIND("$",A1)+1,FIND("-",A1)-FIND("$",A1)-1)

and

=MID(A1,FIND("-",A1)+1,FIND("K ",A1)-FIND("-",A1)-1)

[Jimbo1970]

Thanks NBVC, that does it perfectly and has saved me a lot of time and hassle.

Really appreciate it.

[NBVC]

No problem!