×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

# How can i convert feet-inches to just feet in excel2

## How can i convert feet-inches to just feet in excel

(OP)
Hi folks,

I was wondering how do i convert 5'-9" to 5.75 ft in excel. Any help is appreciated.

Ted.

### RE: How can i convert feet-inches to just feet in excel

Hi,

Is this a column of ft-in dimensions?

If so I'd REPLACE the ' & " characters with nothing and then use Data > Text to columns DELIMITED by -, so you have a column for ft and another for in.

Then it's a simple formula.

Skip,

Just traded in my OLD subtlety...
for a NUance!

### RE: How can i convert feet-inches to just feet in excel

(OP)
SkipVought,

I need the fee-inches to be displayed as #'-#". Do you know of a formula which can take this and convert to strictly inches or feet.

I know the formula to convert 5.75 to 5'-9" (see below), but was not able to do the reverse.
=INT(A2)&"'-"&TRIM(TEXT(ROUND(MOD(A2,1)*12*16,0)/16,"# ??/??")&"""")

### RE: How can i convert feet-inches to just feet in excel

Quite simple to concatenate values to achieve that format...

=A1&"'-"&B1&""""

where A1 is 5 B1 is 9

Result: 5'-9"

Skip,

Just traded in my OLD subtlety...
for a NUance!

### RE: How can i convert feet-inches to just feet in excel

The blog post at:
https://newtonexcelbach.wordpress.com/2014/05/31/f...

looks at various ways of converting to and from a text string containing feet and inches, using both on-sheet formulas and VBA user defined functions.
http://interactiveds.com.au/software/Units4Excel.z...

and also a general unit conversion spreadsheet which will convert a wide range of other units, and also do unit aware evaluation:
http://interactiveds.com.au/software/Units4Excel.z...

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

### RE: How can i convert feet-inches to just feet in excel

If you want it done as a formula:

#### CODE -->

=CONCATENATE(INT(B42),"'-",((B42-INT(B42))*12),"""")

If you want a custom Function ff2fi(x):

#### CODE -->

Function ff2fi(x As String) As String
Dim c
c = Split(x, ".")
feet = c(0)
inches = c(1) / 100 * 12
ff2fi = feet & "'- " & inches & """"
End Function 

### RE: How can i convert feet-inches to just feet in excel

(OP)
Zelgar,

I think this formula converts feet to feet-inch, i want to the opposite (convert feet-in to feet).

### RE: How can i convert feet-inches to just feet in excel

TTFN
FAQ731-376: Eng-Tips.com Forum Policies
[IMG http://tinyurl.com/7ofakss]
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers

Of course I can. I can do anything. I can do absolutely anything. I'm an expert!
There is a homework forum hosted by engineering.com: http://www.engineering.com/AskForum/aff/32.aspx

### RE: How can i convert feet-inches to just feet in excel

2
Sorry.... I was going the opposite decimal feet to feet & inches....
Cell formula:

#### CODE -->

=LEFT(D46,FIND("'",D46)-1)+LEFT(RIGHT(D46,LEN(D46)-FIND("-",D46)),LEN(D46)-FIND("-",D46)-1)/12

Function

#### CODE -->

Function fi2ff(x As String) as Single
Dim d
d = Split(x, "-")
feet = (Left(d(0), Len(d(0)) - 1))
decft = (Left(d(1), Len(d(1)) - 1)) / 12
fi2ff = feet + decft
End Function 

### RE: How can i convert feet-inches to just feet in excel

(OP)
Perfect that works!!

Thanks you all for all your help, really appreciate it.

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Close Box

# Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!