I have a values that show up as Feet and Fractional Inches (41'-10 1/4") and would like to convert it to a decimal value like 41.85
I have a values that show up as Feet and Fractional Inches (41'-10 1/4") and would like to convert it to a decimal value like 41.85
Thanks,
Greg
Not sure exactly how you would like to approach it. If I were given text strings that looked exactly like that, I might:
1) Text to columns or equivalent using "-" as the delimiter to separate ft and inches text string.
2) Use find [(") and (')] and replace (null string) to remove these characters from the feet and inches text. Excel should recognize number (be careful if you have some fractional inches that are less than one. If they are showing up as something that Excel can interpret as a date, Excel will prefer the date interpretation over the fractional number interpretation).
3) Add the two values together, converting inches to feet: =feet+CONVERT(inches,"in","ft").
4) If Excel defaults to a # ?/? number format (carried over from the inches value), change number format to General or 0.00 or whatever you want.
Would something like that work for you, or are there stipulations that I am not aware of?
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks