Hi Manhar,
Use the following formula,
=LEFT(C3,FIND("'",C3,1)-1)+VALUE(MID(C3,FIND("'",C3,1)+1,FIND("""",C3,1)-FIND("'",C3,1)-1))/12
Above formula is for the value entered in Inches in cell C3 and always the
value is expected in Feet(') and Inches("), the forumula also ignores the
multiple spaces beteem the Feet and Inches value.Attaches is the ssheet with solution formula filled with yellow colour. Regards SeenuYarasi On Thu, Feb 10, 2011 at 12:21 PM, manhar prajapati < [email protected]> wrote: > Dear All > I require your urgent help for attach file. > > Please find attach file for calculation of Square meter form Inches to > Centimeter. > > I want to a formula which convert inches in to Centimeter. > > Example > > 10' 3'' is equal to 10.25 for Calculation of Square Feet. > > Thanks and regards > Manhar Prajapati > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Inches.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
