Deriving from 0.5" to 0.5 and so on ..... Values only.

[Aligahk06]

Dear All,

Good day !!!!!!!!!
I have a Column data with following values.
0.5"
0.75"
1"
1.5"
2"
3"
4"
6"
8"
10"
12"
.... upto 56"

I want to derive only numerical fielf for some calculation.
I mean i want to fetch from a common formula that yields 0.5,0.75,1,2, and
so on.

For example
Cell b10 contains 0.5" then in cell D10 i want 0.5
Cell b11 contains 0.75" then in cell D11 i want 0.75
and so on.

Please assist ?

Rgds,

Aligahk06

 

[Mike H]

Hi,

=LEFT(B10,LEN(B10)-1)+0


Drag down as required. The +0 isn't strictly necessary it just makes it
right justify.

Mike

 

[Jacob Skaria]

Another way...

=--SUBSTITUTE(A1,CHAR(34),)

OR

=SUBSTITUTE(A1,CHAR(34),)+0


If this post helps click Yes