software

I have the following in cells
D3: -2.5 -111
D4: 2.5 101
D5: 10.5 -114
D6: -10.5 104
D7: -8 100
D8: 8 -110

Is there a formula I can enter into cell H3 that will give me just -2.5?
Note that all the cells aren't necessarily in the same format (some are X.5
and some are X). Thanks

This formula
=MID(D3,1,FIND(quot; quot;,D3,1)-1)
.... looks for the space in between the numbers, and pulls everything to
the left of the space.Assuming all of your cells follow the same format as Number - Space - Number,
then this will work to extract the first number before the space:

=LEFT(D3,FIND(quot; quot;,D3,1)-1)

HTH,
Elkar

quot;Jambruinsquot; wrote:

gt; I have the following in cells
gt; D3: -2.5 -111
gt; D4: 2.5 101
gt; D5: 10.5 -114
gt; D6: -10.5 104
gt; D7: -8 100
gt; D8: 8 -110
gt;
gt; Is there a formula I can enter into cell H3 that will give me just -2.5?
gt; Note that all the cells aren't necessarily in the same format (some are X.5
gt; and some are X). Thanks

Assuming that in cell D3 you have a space after the first number and the cell
is formatted as text, in cell H3 type the following formula:
=MID(D3,1,FIND(quot; quot;,D#,1)-1) and copy down. Note that there is a single space
between the two quotation marks.quot;Jambruinsquot; wrote:

gt; I have the following in cells
gt; D3: -2.5 -111
gt; D4: 2.5 101
gt; D5: 10.5 -114
gt; D6: -10.5 104
gt; D7: -8 100
gt; D8: 8 -110
gt;
gt; Is there a formula I can enter into cell H3 that will give me just -2.5?
gt; Note that all the cells aren't necessarily in the same format (some are X.5
gt; and some are X). Thanks

thanks to all three of you for the help

quot;SVCquot; wrote:

gt; Assuming that in cell D3 you have a space after the first number and the cell
gt; is formatted as text, in cell H3 type the following formula:
gt; =MID(D3,1,FIND(quot; quot;,D#,1)-1) and copy down. Note that there is a single space
gt; between the two quotation marks.
gt;
gt;
gt; quot;Jambruinsquot; wrote:
gt;
gt; gt; I have the following in cells
gt; gt; D3: -2.5 -111
gt; gt; D4: 2.5 101
gt; gt; D5: 10.5 -114
gt; gt; D6: -10.5 104
gt; gt; D7: -8 100
gt; gt; D8: 8 -110
gt; gt;
gt; gt; Is there a formula I can enter into cell H3 that will give me just -2.5?
gt; gt; Note that all the cells aren't necessarily in the same format (some are X.5
gt; gt; and some are X). Thanks

how would I change the formula to pull everything to the right of the space?

quot;Dave Oquot; wrote:

gt; This formula
gt; =MID(D3,1,FIND(quot; quot;,D3,1)-1)
gt; .... looks for the space in between the numbers, and pulls everything to
gt; the left of the space.
gt;
gt;

One way:

=MID(D3,FIND(quot; quot;,D3) 1,100)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;Jambruinsquot; gt; wrote in message
...
gt; how would I change the formula to pull everything to the right of the
space?
gt;
gt; quot;Dave Oquot; wrote:
gt;
gt; gt; This formula
gt; gt; =MID(D3,1,FIND(quot; quot;,D3,1)-1)
gt; gt; .... looks for the space in between the numbers, and pulls everything to
gt; gt; the left of the space.
gt; gt;
gt; gt;gt; ...Split text ...

If D3 does in fact have quot;Textquot;, then a possible alternative...

=IMREAL(D3amp; quot;jquot;)

HTH. :gt;)
--
Dana DeLouis
Win XP amp; Office 2003quot;Jambruinsquot; gt; wrote in message
...
gt;I have the following in cells
gt; D3: -2.5 -111
gt; D4: 2.5 101
gt; D5: 10.5 -114
gt; D6: -10.5 104
gt; D7: -8 100
gt; D8: 8 -110
gt;
gt; Is there a formula I can enter into cell H3 that will give me just -2.5?
gt; Note that all the cells aren't necessarily in the same format (some are
gt; X.5
gt; and some are X). Thanks