Hi, I am trying to convert athlete's heights (formatted ex. 6'4) into inches.
up vote
-1
down vote
favorite
I've seen several other forums where this has been performed using different number formatting (i.e. 6ft 4inches), but not for this format. If you could provide some insight into the functions you're using, that would be great!
excel excel-formula formatting inches
asked Nov 19 at 21:06
Drew
1
add a comment |
up vote
-1
down vote
favorite
I've seen several other forums where this has been performed using different number formatting (i.e. 6ft 4inches), but not for this format. If you could provide some insight into the functions you're using, that would be great!
excel excel-formula formatting inches
asked Nov 19 at 21:06
Drew
1
Welcome to StackOverflow! Please update your question to show what you have already tried in a Minimal, Complete, and Verifiable example. For further information, please see How to Ask.
– Raoslaw Szamszur
Nov 19 at 21:13
If it's6ft 4inchesthen it's a split on space and you have inches and feet separated. Just need to convert the feet to inches and sum it.
– Andreas
Nov 19 at 21:14
2
@Drew you need to show a few examples of what your starting string looks like. Then we can help you figure out how to get to the end string. We have no knowledge of what your starting string looks like
– urdearboy
Nov 19 at 21:17
idownvotedbecau.se/beingunresponsive
– urdearboy
Nov 19 at 21:31
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I've seen several other forums where this has been performed using different number formatting (i.e. 6ft 4inches), but not for this format. If you could provide some insight into the functions you're using, that would be great!
excel excel-formula formatting inches
asked Nov 19 at 21:06
Drew
1
I've seen several other forums where this has been performed using different number formatting (i.e. 6ft 4inches), but not for this format. If you could provide some insight into the functions you're using, that would be great!
excel excel-formula formatting inches
excel excel-formula formatting inches
asked Nov 19 at 21:06
Drew
1
asked Nov 19 at 21:06
Drew
1
asked Nov 19 at 21:06
Drew
1
asked Nov 19 at 21:06
Drew
1
asked Nov 19 at 21:06
Drew
1
1
Welcome to StackOverflow! Please update your question to show what you have already tried in a Minimal, Complete, and Verifiable example. For further information, please see How to Ask.
– Raoslaw Szamszur
Nov 19 at 21:13
If it's6ft 4inchesthen it's a split on space and you have inches and feet separated. Just need to convert the feet to inches and sum it.
– Andreas
Nov 19 at 21:14
2
@Drew you need to show a few examples of what your starting string looks like. Then we can help you figure out how to get to the end string. We have no knowledge of what your starting string looks like
– urdearboy
Nov 19 at 21:17
idownvotedbecau.se/beingunresponsive
– urdearboy
Nov 19 at 21:31
add a comment |
Welcome to StackOverflow! Please update your question to show what you have already tried in a Minimal, Complete, and Verifiable example. For further information, please see How to Ask.
– Raoslaw Szamszur
Nov 19 at 21:13
If it's6ft 4inchesthen it's a split on space and you have inches and feet separated. Just need to convert the feet to inches and sum it.
– Andreas
Nov 19 at 21:14
2
@Drew you need to show a few examples of what your starting string looks like. Then we can help you figure out how to get to the end string. We have no knowledge of what your starting string looks like
– urdearboy
Nov 19 at 21:17
idownvotedbecau.se/beingunresponsive
– urdearboy
Nov 19 at 21:31
Welcome to StackOverflow! Please update your question to show what you have already tried in a Minimal, Complete, and Verifiable example. For further information, please see How to Ask.
– Raoslaw Szamszur
Nov 19 at 21:13
Welcome to StackOverflow! Please update your question to show what you have already tried in a Minimal, Complete, and Verifiable example. For further information, please see How to Ask.
– Raoslaw Szamszur
Nov 19 at 21:13
If it's
6ft 4inches then it's a split on space and you have inches and feet separated. Just need to convert the feet to inches and sum it.– Andreas
Nov 19 at 21:14
If it's
6ft 4inches then it's a split on space and you have inches and feet separated. Just need to convert the feet to inches and sum it.– Andreas
Nov 19 at 21:14
2
2
@Drew you need to show a few examples of what your starting string looks like. Then we can help you figure out how to get to the end string. We have no knowledge of what your starting string looks like
– urdearboy
Nov 19 at 21:17
@Drew you need to show a few examples of what your starting string looks like. Then we can help you figure out how to get to the end string. We have no knowledge of what your starting string looks like
– urdearboy
Nov 19 at 21:17
idownvotedbecau.se/beingunresponsive
– urdearboy
Nov 19 at 21:31
idownvotedbecau.se/beingunresponsive
– urdearboy
Nov 19 at 21:31
add a comment |
2 Answers
2
active
oldest
votes
up vote
0
down vote
Excel does have a number of cell formatting options, for numbers (currency, scientific, etc.), dates, and time, but, to my knowledge, not for other type of numbers, so you will have to convert this with a formula.
Assuming your input is in the format 6'4, this formula will give you the conversion into inches:=CONVERT(LEFT(A1;FIND("'";A1)-1);"ft";"in")+RIGHT(A1;LEN(A1)-FIND("'";A1))
The formula splits the 6'4 text string into two parts, based on the position of the ', with the LEFT and RIGHT functions, and uses the built-in CONVERT formula to convert feet into inches.
And of course, change the semicolons into commas as needed according to your settings.
And it is the same principle if the input is different, let's assume 6 feet 4 inches with some random spaces thrown in. The search parameter is now feet and not '. I also use SEARCH instead of FIND as this is case insensitive, so Feet and feet will give same result; I substitute the "inches" with empty string; to get rid of spaces and other junk that could be in the text string, I use TRIM(CLEAN()); and finally I wrap with NUMBERVALUE to convert text into number (in same cases this is not necessary, but I put it to be sure) :=CONVERT(NUMBERVALUE(TRIM(CLEAN(LEFT(A1;SEARCH("feet";A1)-1))));"ft";"in") +NUMBERVALUE(TRIM(SUBSTITUTE((CLEAN(RIGHT(A1;LEN(A1)-SEARCH("feet";A1)-3)));"inches";"")))
answered Nov 19 at 21:32
Peter K.
723111
1
@urdearboy Yeah indeed, I just took the assumption from the title for the conversion formula. But this will remain basically the same if the input is slightly different, by changing the'with ft or feet or whatever, and just remove the in or inches through aREPLACEwith empty string. And yeah, he is not very responsive, but maybe he is in a different timezone and posted the question before going to bed (which I do sometimes). So I always give someone 24hr to react/answer, before I am getting annoyed about non-responsiveness ;)
– Peter K.
Nov 19 at 21:49
I think you should be most responsive when you first post your question since people will have clarifying questions sometimes. If they don't respond, people (volunteers in this case) have just wasted there time. If a response is given the next day, chances are we forgot the problem and will have to re-read the question
– urdearboy
Nov 19 at 21:51
Thank you PeterK! Apologies for the delay. Been a bit hectic around here...I'll make sure to more carefully monitor my future posts for replies. Assuming the cell I'm trying to convert is cell F2, do I replace all mentions of "A1" with "F2"?
– Drew
Nov 19 at 23:42
No problem. Within 24hrs is fine ;) And yes, I put the test in A1, so you have to replace this with where your input cell is.
– Peter K.
Nov 19 at 23:51
Greatly appreciated! Works flawlessly.
– Drew
Nov 20 at 0:48
|
show 1 more comment
up vote
0
down vote
Here is a simpler way to convert the height into inches:
=LEFT(A1,1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-1)
(assuming that your data starts in cell A1)
The left function converts the feet into inches and the mid(find) function finds the inches and adds it to the total.
answered Nov 21 at 16:50
JoeJam
12710
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53382629%2fhi-i-am-trying-to-convert-athletes-heights-formatted-ex-64-into-inches%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
Excel does have a number of cell formatting options, for numbers (currency, scientific, etc.), dates, and time, but, to my knowledge, not for other type of numbers, so you will have to convert this with a formula.
Assuming your input is in the format 6'4, this formula will give you the conversion into inches:=CONVERT(LEFT(A1;FIND("'";A1)-1);"ft";"in")+RIGHT(A1;LEN(A1)-FIND("'";A1))
The formula splits the 6'4 text string into two parts, based on the position of the ', with the LEFT and RIGHT functions, and uses the built-in CONVERT formula to convert feet into inches.
And of course, change the semicolons into commas as needed according to your settings.
And it is the same principle if the input is different, let's assume 6 feet 4 inches with some random spaces thrown in. The search parameter is now feet and not '. I also use SEARCH instead of FIND as this is case insensitive, so Feet and feet will give same result; I substitute the "inches" with empty string; to get rid of spaces and other junk that could be in the text string, I use TRIM(CLEAN()); and finally I wrap with NUMBERVALUE to convert text into number (in same cases this is not necessary, but I put it to be sure) :=CONVERT(NUMBERVALUE(TRIM(CLEAN(LEFT(A1;SEARCH("feet";A1)-1))));"ft";"in") +NUMBERVALUE(TRIM(SUBSTITUTE((CLEAN(RIGHT(A1;LEN(A1)-SEARCH("feet";A1)-3)));"inches";"")))
answered Nov 19 at 21:32
Peter K.
723111
1
@urdearboy Yeah indeed, I just took the assumption from the title for the conversion formula. But this will remain basically the same if the input is slightly different, by changing the'with ft or feet or whatever, and just remove the in or inches through aREPLACEwith empty string. And yeah, he is not very responsive, but maybe he is in a different timezone and posted the question before going to bed (which I do sometimes). So I always give someone 24hr to react/answer, before I am getting annoyed about non-responsiveness ;)
– Peter K.
Nov 19 at 21:49
I think you should be most responsive when you first post your question since people will have clarifying questions sometimes. If they don't respond, people (volunteers in this case) have just wasted there time. If a response is given the next day, chances are we forgot the problem and will have to re-read the question
– urdearboy
Nov 19 at 21:51
Thank you PeterK! Apologies for the delay. Been a bit hectic around here...I'll make sure to more carefully monitor my future posts for replies. Assuming the cell I'm trying to convert is cell F2, do I replace all mentions of "A1" with "F2"?
– Drew
Nov 19 at 23:42
No problem. Within 24hrs is fine ;) And yes, I put the test in A1, so you have to replace this with where your input cell is.
– Peter K.
Nov 19 at 23:51
Greatly appreciated! Works flawlessly.
– Drew
Nov 20 at 0:48
|
show 1 more comment
up vote
0
down vote
Excel does have a number of cell formatting options, for numbers (currency, scientific, etc.), dates, and time, but, to my knowledge, not for other type of numbers, so you will have to convert this with a formula.
Assuming your input is in the format 6'4, this formula will give you the conversion into inches:=CONVERT(LEFT(A1;FIND("'";A1)-1);"ft";"in")+RIGHT(A1;LEN(A1)-FIND("'";A1))
The formula splits the 6'4 text string into two parts, based on the position of the ', with the LEFT and RIGHT functions, and uses the built-in CONVERT formula to convert feet into inches.
And of course, change the semicolons into commas as needed according to your settings.
And it is the same principle if the input is different, let's assume 6 feet 4 inches with some random spaces thrown in. The search parameter is now feet and not '. I also use SEARCH instead of FIND as this is case insensitive, so Feet and feet will give same result; I substitute the "inches" with empty string; to get rid of spaces and other junk that could be in the text string, I use TRIM(CLEAN()); and finally I wrap with NUMBERVALUE to convert text into number (in same cases this is not necessary, but I put it to be sure) :=CONVERT(NUMBERVALUE(TRIM(CLEAN(LEFT(A1;SEARCH("feet";A1)-1))));"ft";"in") +NUMBERVALUE(TRIM(SUBSTITUTE((CLEAN(RIGHT(A1;LEN(A1)-SEARCH("feet";A1)-3)));"inches";"")))
answered Nov 19 at 21:32
Peter K.
723111
1
@urdearboy Yeah indeed, I just took the assumption from the title for the conversion formula. But this will remain basically the same if the input is slightly different, by changing the'with ft or feet or whatever, and just remove the in or inches through aREPLACEwith empty string. And yeah, he is not very responsive, but maybe he is in a different timezone and posted the question before going to bed (which I do sometimes). So I always give someone 24hr to react/answer, before I am getting annoyed about non-responsiveness ;)
– Peter K.
Nov 19 at 21:49
I think you should be most responsive when you first post your question since people will have clarifying questions sometimes. If they don't respond, people (volunteers in this case) have just wasted there time. If a response is given the next day, chances are we forgot the problem and will have to re-read the question
– urdearboy
Nov 19 at 21:51
Thank you PeterK! Apologies for the delay. Been a bit hectic around here...I'll make sure to more carefully monitor my future posts for replies. Assuming the cell I'm trying to convert is cell F2, do I replace all mentions of "A1" with "F2"?
– Drew
Nov 19 at 23:42
No problem. Within 24hrs is fine ;) And yes, I put the test in A1, so you have to replace this with where your input cell is.
– Peter K.
Nov 19 at 23:51
Greatly appreciated! Works flawlessly.
– Drew
Nov 20 at 0:48
|
show 1 more comment
up vote
0
down vote
up vote
0
down vote
Excel does have a number of cell formatting options, for numbers (currency, scientific, etc.), dates, and time, but, to my knowledge, not for other type of numbers, so you will have to convert this with a formula.
Assuming your input is in the format 6'4, this formula will give you the conversion into inches:=CONVERT(LEFT(A1;FIND("'";A1)-1);"ft";"in")+RIGHT(A1;LEN(A1)-FIND("'";A1))
The formula splits the 6'4 text string into two parts, based on the position of the ', with the LEFT and RIGHT functions, and uses the built-in CONVERT formula to convert feet into inches.
And of course, change the semicolons into commas as needed according to your settings.
And it is the same principle if the input is different, let's assume 6 feet 4 inches with some random spaces thrown in. The search parameter is now feet and not '. I also use SEARCH instead of FIND as this is case insensitive, so Feet and feet will give same result; I substitute the "inches" with empty string; to get rid of spaces and other junk that could be in the text string, I use TRIM(CLEAN()); and finally I wrap with NUMBERVALUE to convert text into number (in same cases this is not necessary, but I put it to be sure) :=CONVERT(NUMBERVALUE(TRIM(CLEAN(LEFT(A1;SEARCH("feet";A1)-1))));"ft";"in") +NUMBERVALUE(TRIM(SUBSTITUTE((CLEAN(RIGHT(A1;LEN(A1)-SEARCH("feet";A1)-3)));"inches";"")))
answered Nov 19 at 21:32
Peter K.
723111
Excel does have a number of cell formatting options, for numbers (currency, scientific, etc.), dates, and time, but, to my knowledge, not for other type of numbers, so you will have to convert this with a formula.
Assuming your input is in the format 6'4, this formula will give you the conversion into inches:=CONVERT(LEFT(A1;FIND("'";A1)-1);"ft";"in")+RIGHT(A1;LEN(A1)-FIND("'";A1))
The formula splits the 6'4 text string into two parts, based on the position of the ', with the LEFT and RIGHT functions, and uses the built-in CONVERT formula to convert feet into inches.
And of course, change the semicolons into commas as needed according to your settings.
And it is the same principle if the input is different, let's assume 6 feet 4 inches with some random spaces thrown in. The search parameter is now feet and not '. I also use SEARCH instead of FIND as this is case insensitive, so Feet and feet will give same result; I substitute the "inches" with empty string; to get rid of spaces and other junk that could be in the text string, I use TRIM(CLEAN()); and finally I wrap with NUMBERVALUE to convert text into number (in same cases this is not necessary, but I put it to be sure) :=CONVERT(NUMBERVALUE(TRIM(CLEAN(LEFT(A1;SEARCH("feet";A1)-1))));"ft";"in") +NUMBERVALUE(TRIM(SUBSTITUTE((CLEAN(RIGHT(A1;LEN(A1)-SEARCH("feet";A1)-3)));"inches";"")))
answered Nov 19 at 21:32
Peter K.
723111
edited Nov 19 at 22:40
answered Nov 19 at 21:32
Peter K.
723111
answered Nov 19 at 21:32
Peter K.
723111
answered Nov 19 at 21:32
Peter K.
723111
723111
1
@urdearboy Yeah indeed, I just took the assumption from the title for the conversion formula. But this will remain basically the same if the input is slightly different, by changing the'with ft or feet or whatever, and just remove the in or inches through aREPLACEwith empty string. And yeah, he is not very responsive, but maybe he is in a different timezone and posted the question before going to bed (which I do sometimes). So I always give someone 24hr to react/answer, before I am getting annoyed about non-responsiveness ;)
– Peter K.
Nov 19 at 21:49
I think you should be most responsive when you first post your question since people will have clarifying questions sometimes. If they don't respond, people (volunteers in this case) have just wasted there time. If a response is given the next day, chances are we forgot the problem and will have to re-read the question
– urdearboy
Nov 19 at 21:51
Thank you PeterK! Apologies for the delay. Been a bit hectic around here...I'll make sure to more carefully monitor my future posts for replies. Assuming the cell I'm trying to convert is cell F2, do I replace all mentions of "A1" with "F2"?
– Drew
Nov 19 at 23:42
No problem. Within 24hrs is fine ;) And yes, I put the test in A1, so you have to replace this with where your input cell is.
– Peter K.
Nov 19 at 23:51
Greatly appreciated! Works flawlessly.
– Drew
Nov 20 at 0:48
|
show 1 more comment
1
@urdearboy Yeah indeed, I just took the assumption from the title for the conversion formula. But this will remain basically the same if the input is slightly different, by changing the'with ft or feet or whatever, and just remove the in or inches through aREPLACEwith empty string. And yeah, he is not very responsive, but maybe he is in a different timezone and posted the question before going to bed (which I do sometimes). So I always give someone 24hr to react/answer, before I am getting annoyed about non-responsiveness ;)
– Peter K.
Nov 19 at 21:49
I think you should be most responsive when you first post your question since people will have clarifying questions sometimes. If they don't respond, people (volunteers in this case) have just wasted there time. If a response is given the next day, chances are we forgot the problem and will have to re-read the question
– urdearboy
Nov 19 at 21:51
Thank you PeterK! Apologies for the delay. Been a bit hectic around here...I'll make sure to more carefully monitor my future posts for replies. Assuming the cell I'm trying to convert is cell F2, do I replace all mentions of "A1" with "F2"?
– Drew
Nov 19 at 23:42
No problem. Within 24hrs is fine ;) And yes, I put the test in A1, so you have to replace this with where your input cell is.
– Peter K.
Nov 19 at 23:51
Greatly appreciated! Works flawlessly.
– Drew
Nov 20 at 0:48
1
1
@urdearboy Yeah indeed, I just took the assumption from the title for the conversion formula. But this will remain basically the same if the input is slightly different, by changing the
' with ft or feet or whatever, and just remove the in or inches through a REPLACE with empty string. And yeah, he is not very responsive, but maybe he is in a different timezone and posted the question before going to bed (which I do sometimes). So I always give someone 24hr to react/answer, before I am getting annoyed about non-responsiveness ;)– Peter K.
Nov 19 at 21:49
@urdearboy Yeah indeed, I just took the assumption from the title for the conversion formula. But this will remain basically the same if the input is slightly different, by changing the
' with ft or feet or whatever, and just remove the in or inches through a REPLACE with empty string. And yeah, he is not very responsive, but maybe he is in a different timezone and posted the question before going to bed (which I do sometimes). So I always give someone 24hr to react/answer, before I am getting annoyed about non-responsiveness ;)– Peter K.
Nov 19 at 21:49
I think you should be most responsive when you first post your question since people will have clarifying questions sometimes. If they don't respond, people (volunteers in this case) have just wasted there time. If a response is given the next day, chances are we forgot the problem and will have to re-read the question
– urdearboy
Nov 19 at 21:51
I think you should be most responsive when you first post your question since people will have clarifying questions sometimes. If they don't respond, people (volunteers in this case) have just wasted there time. If a response is given the next day, chances are we forgot the problem and will have to re-read the question
– urdearboy
Nov 19 at 21:51
Thank you PeterK! Apologies for the delay. Been a bit hectic around here...I'll make sure to more carefully monitor my future posts for replies. Assuming the cell I'm trying to convert is cell F2, do I replace all mentions of "A1" with "F2"?
– Drew
Nov 19 at 23:42
Thank you PeterK! Apologies for the delay. Been a bit hectic around here...I'll make sure to more carefully monitor my future posts for replies. Assuming the cell I'm trying to convert is cell F2, do I replace all mentions of "A1" with "F2"?
– Drew
Nov 19 at 23:42
No problem. Within 24hrs is fine ;) And yes, I put the test in A1, so you have to replace this with where your input cell is.
– Peter K.
Nov 19 at 23:51
No problem. Within 24hrs is fine ;) And yes, I put the test in A1, so you have to replace this with where your input cell is.
– Peter K.
Nov 19 at 23:51
Greatly appreciated! Works flawlessly.
– Drew
Nov 20 at 0:48
Greatly appreciated! Works flawlessly.
– Drew
Nov 20 at 0:48
|
show 1 more comment
up vote
0
down vote
Here is a simpler way to convert the height into inches:
=LEFT(A1,1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-1)
(assuming that your data starts in cell A1)
The left function converts the feet into inches and the mid(find) function finds the inches and adds it to the total.
answered Nov 21 at 16:50
JoeJam
12710
add a comment |
up vote
0
down vote
Here is a simpler way to convert the height into inches:
=LEFT(A1,1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-1)
(assuming that your data starts in cell A1)
The left function converts the feet into inches and the mid(find) function finds the inches and adds it to the total.
answered Nov 21 at 16:50
JoeJam
12710
add a comment |
up vote
0
down vote
up vote
0
down vote
Here is a simpler way to convert the height into inches:
=LEFT(A1,1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-1)
(assuming that your data starts in cell A1)
The left function converts the feet into inches and the mid(find) function finds the inches and adds it to the total.
answered Nov 21 at 16:50
JoeJam
12710
Here is a simpler way to convert the height into inches:
=LEFT(A1,1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-1)
(assuming that your data starts in cell A1)
The left function converts the feet into inches and the mid(find) function finds the inches and adds it to the total.
answered Nov 21 at 16:50
JoeJam
12710
answered Nov 21 at 16:50
JoeJam
12710
answered Nov 21 at 16:50
JoeJam
12710
answered Nov 21 at 16:50
JoeJam
12710
12710
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53382629%2fhi-i-am-trying-to-convert-athletes-heights-formatted-ex-64-into-inches%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Welcome to StackOverflow! Please update your question to show what you have already tried in a Minimal, Complete, and Verifiable example. For further information, please see How to Ask.
– Raoslaw Szamszur
Nov 19 at 21:13
If it's
6ft 4inchesthen it's a split on space and you have inches and feet separated. Just need to convert the feet to inches and sum it.– Andreas
Nov 19 at 21:14
2
@Drew you need to show a few examples of what your starting string looks like. Then we can help you figure out how to get to the end string. We have no knowledge of what your starting string looks like
– urdearboy
Nov 19 at 21:17
idownvotedbecau.se/beingunresponsive
– urdearboy
Nov 19 at 21:31