View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Saxman
 
Posts: n/a
Default Help With Parsing Data

On Tue, 27 Dec 2005 23:28:58 +1030, OZDOC1050 wrote:

I also wondered if there was a better way of cleaning up the 'K's' in the
following data, without doing a find/replace? These could appear column
N.

50K
20K
20K
22K
140K
14K
15K
25K
25K
18K


I have sorted this with the help of the first formula!

=LEFT(F6,FIND("K",F6,1)-1)