So I'm trying to pull data from a set. The info I need is the numbers around a decimal.
<tbody>
</tbody>
I have been using the formula =MID(A1,FIND(".",A1,1),3) so I can get the numbers after the decimal but how can I get JUST the number before? Using LEFT function will not work because it just pulls from the beginning.
Have | Need |
Intel Core 2.14 GHz | 2.14 |
AMD Core 1.99 GHz | 1.99 |
Intel Pentium 2.56 GHz | 2.56 |
<tbody>
</tbody>
I have been using the formula =MID(A1,FIND(".",A1,1),3) so I can get the numbers after the decimal but how can I get JUST the number before? Using LEFT function will not work because it just pulls from the beginning.