Convert Feet - Inch - Inch Fraction string into numerical value

Hello,
I have a string in a cell which looks like:
5’ – 4”
Or,
11’-6 11/16”
Or,
2’- 0 1/8”
And so forth... (values might be different every time)
I need to pull out the numerical values from these strings in order to operate and get the arithmetical values of those measurements.
Here is what I am struggling with:
1. Get the numerical value of the string preceding the “ ‘ “ sign.
2. Get a message box : String contains “/” sign when there is one.
3. Get the numerical value between the “-“ sign and the “ “ “ sign when no “/” exists
4. Get the numerical value between the “-“ sign and the fraction following the last gap
5. Get the numerical value of the fraction following the last gap, preceding the " " " sign when “/” exists.
Or, any other idea to extract the numerical value of the string , would be appreciated.
Perhaps there is a routine already for this?
Thanks

5'-4" is 64"
The "-" sign is just a formatting / marker to separate the Feet from Inches
Thanks

mikereickson,
Thanks for the response; I am not quite familiar with UDF.
How do I call the function in my subroutine?

Is it something like
NumValue = FInch2Inch(Activecell.value) ?
Thanks