Extract numbers with units. Eg. 1.6mmÂ², 20.23mmÂ²

Posted to microsoft.public.excel.worksheet.functions

Francis WF Lee

Posts: n/a

Extract numbers with units. Eg. 1.6mmÂ², 20.23mmÂ²

I need 1.6 from 1.6mmÂ² and 20.23 from 20.23mmÂ²

1) I cannot use RIGHT function to extract as number starts from left.
2) I cannot use LEFT function as number is not fix length
3) I cannot use MID function as num_start refererence is from left not right

Following also some example which difficult to extract
1) 100.2Volts, 15Volts
2) 20m/s, 1.25m/s, 10.0m/s
3) 1.235mÃ˜, 34.0mÃ˜

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Seed numbers for random number generation, uniform distribution	darebo	Excel Discussion (Misc queries)	3	April 21st 23 09:02 PM
Sorting when some numbers have a text suffix	confused on the tundra	Excel Discussion (Misc queries)	5	December 18th 04 10:19 PM
Sorting imported "numbers"	Confused on the tundra	Excel Discussion (Misc queries)	5	December 17th 04 07:33 PM
How do you extract numbers from a string of chacters in a cell (E.	blackbeemer	Excel Worksheet Functions	6	November 12th 04 09:00 AM
finding common numbers in large lists	Jenn	Excel Worksheet Functions	1	November 11th 04 07:42 PM

All times are GMT +1. The time now is 09:28 AM.

Menu

About Us