K
kaytoo
I'm looking for the formula that would extract the numbers in a cel
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 m
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 carriag
returns???
spaces might work in this case, too..
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 m
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 carriag
returns???
spaces might work in this case, too..