Hello, this is a relatively simple question, but I can't find the answer anywhere.
(PS: I have installed 'Analysis Toolpak' Add-in)
I need a formula to convert sports players' heights, from feet and inches to meters.
I added a column named Height (in) in the middle, in case it's necessary to convert to inches first and then to meters. I could hide it afterwards.
Thank you
try these two
=CONVERT(B2,"ft","in")
=CONVERT(C2,"in","m")
But you need to change values in column B to numeric. Instead of 5'3" to 5.3
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
In C2,
=LEFT(B2, FIND("'", B2) - 1) * 12 + IFERROR(MID(B2, FIND("'", B2) + 1, FIND("""", B2) - FIND("'", B2) - 1), 0)
Entia non sunt multiplicanda sine necessitate
Thank you AlKey, but I would very much like to keep column B displayed as it is.
shg, you solved it, thank you so much!
Then this
=CONVERT(SUBSTITUTE(SUBSTITUTE(B2,"'","."),"""","")+0,"ft","in")
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks