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

A

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
 
M

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
 
J

Jacob Skaria

Another way...

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

OR

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


If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top