Foot and inches with fractions to inches and decimal points

[Dee]

Morning,

We have a program that exports a table to excel. It exports using feet,
inches and fractions eg 6'-5 1/2" or 4'-0".
I'm looking for a way to convert this to inches and decimal points and all
the -, ', " removed.
for example 6'-5 1/2" will be 77.5 and 4'-0" will be 48

Any ideas? It's a huge spreadsheet and doing each conversion individually
will drive me nuts.

Cheers in advance

Dee

 

[DL]

I wonder what db produced the origonal table?

 

[Dee]

It's from Autocad, using a program called table builder to export to Excel.

 

[DL]

I was hoping something else might be involved.

I'd suggest you post to one of the Excel specific ng's
I believe macros or vb will be required