change to number format

A

aupeter

I am new to the forum, so some help would be appreciated.

I have data in the form of 132 ' 30 which represents 132 30/32.

If someone could show me how to convert into the /32, I would appreciate it.,.


Thanks

AU
 
D

DILipandey

Hi Aupeter,

Assuming that you have this data in Cell A1, use the following formula:-

=MID(A1,1,FIND("'",A1)-2)&""&RIGHT(A1,(LEN(A1)-FIND("'",A1)))&""&"/32"

Please click on "yes" if it helps..Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
[email protected]
[email protected]
New Delhi, India
 
Top