Morning,

We have a program that exports a table from Auto-cad to Excel, using a
program called TableBuilder. 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