Change height (5'8") to inches (68)

  • Thread starter Thread starter Russ3Z
  • Start date Start date
R

Russ3Z

As the subject says, I am looking for a way to convert a column of
heights, expressed with the ' and " symbols for feet and inches,
respectively, into just a number of inches. If possible I would like
to do this without using a macro. So the following:

6'2"
5'3"
5'8"

would become

74
63
68

Any help is most appreciated. Thank you.
 
=LEFT(A1,FIND("'",A1)-1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-FIND("'",A1)-1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| As the subject says, I am looking for a way to convert a column of
| heights, expressed with the ' and " symbols for feet and inches,
| respectively, into just a number of inches. If possible I would like
| to do this without using a macro. So the following:
|
| 6'2"
| 5'3"
| 5'8"
|
| would become
|
| 74
| 63
| 68
|
| Any help is most appreciated. Thank you.
 
Maybe...
=(MID(A1,1,FIND("'",A1)-1)*12)+MID(A1,FIND("'",A1)+1,FIND("""",A1)-
FIND("'",A1)-1)
 
As the subject says, I am looking for a way to convert a column of
heights, expressed with the ' and " symbols for feet and inches,
respectively, into just a number of inches. If possible I would like
to do this without using a macro. So the following:

6'2"
5'3"
5'8"

would become

74
63
68

Any help is most appreciated. Thank you.
Click to expand...


=REPLACE(A1,FIND("'",A1),5,"")*12+SUBSTITUTE(MID(A1,FIND("'",A1)+1,5),"""","")

--ron
 
Bonsour® Russ3Z avec ferveur ;o))) vous nous disiez :
As the subject says, I am looking for a way to convert a column of
heights, expressed with the ' and " symbols for feet and inches,
respectively, into just a number of inches. If possible I would like
to do this without using a macro. So the following:
6'2"
5'3"
5'8"
would become
74
63
68
Click to expand...

=CONVERT(SUBSTITUTE(SUBSTITUTE(A1,CHAR(34),"/12"),CHAR(39)," "),"ft","in")

HTH
 
Back
Top