Forum Discussion
Imperial measurements
John_JohnsonJohnJohn The comment column would need to be cleaned-up, the unit of measurement extracted and broken down to number values. You can do that with a number ofhelper columns with, for example, IF and SUBSTITUTE functions. Personally, I'd prefer a solution using PowerQuery though. Both are provided in the attached file. With PowerQuery, you would normally connect to the csv file. In this case, I loaded the csv data into Excel and used PowerQuery from there.
Riny_van_Eekelen Yes! great, thanks, this is what I needed. Now I have the ft-in data converted into LF (with decimals) and can add up all the same Wall Types sections, etc. The #'-#" was output from another program I used for takeoff and now I can use it other spreadsheets.
John_JohnsonJohnJohn Glad I could help resolve your problem.