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

[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.

 

[Niek Otten]

=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.

 

[a.muppet.man]

Maybe...
=(MID(A1,1,FIND("'",A1)-1)*12)+MID(A1,FIND("'",A1)+1,FIND("""",A1)-
FIND("'",A1)-1)

 

[Ron Rosenfeld]

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.

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

--ron

 

[Mais qui est Paul ?]

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

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

HTH