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)
|