I'm looking for the formula that would extract the numbers in a cell
like below in to three seperate cells:

This is the contents of one cell:
_______
| 3.3 |
| 9.5 |
| 12.5 |
-----

I know "=LEFT(A1,3)" will give me 3.3 and "=RIGHT(A1,4)" will give me
12.5

but....what if 3.3 was 10.3? My formula would only give me 0.3.

And... I need to extract 9.5 somehow (which could be -X.X or XX.X)

Is there a way to count text strings before and after carriage
returns???
spaces might work in this case, too...


--
kaytoo
------------------------------------------------------------------------
kaytoo's Profile: http://www.excelforum.com/member.php...o&userid=34057
View this thread: http://www.excelforum.com/showthread...hreadid=538210