Posted to microsoft.public.excel.misc

Saxman

Posts: n/a

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)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing Data	Jillian	Excel Worksheet Functions	9	December 23rd 05 12:45 PM
Parsing Data	Saxman	Excel Discussion (Misc queries)	4	December 8th 05 08:31 AM
Excel Macro to Copy & Paste	[email protected]	Excel Worksheet Functions	0	December 1st 05 01:56 PM
The SEARCH function and parsing data	Michael	Excel Worksheet Functions	2	September 19th 05 05:36 PM
Line Graph Data Recognition	Nat	Charts and Charting in Excel	2	April 30th 05 02:07 PM

All times are GMT +1. The time now is 04:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us