Apr 18 2021 08:57 PM
How can I convert data with imperial measurements such as 61'-8" into usable values that can be added together etc.?
Apr 18 2021 10:37 PM
Apr 19 2021 02:46 AM
Solution@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.
Apr 19 2021 07:20 AM
@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.
Apr 19 2021 07:23 AM
@John_JohnsonJohnJohn Glad I could help resolve your problem.
Apr 19 2021 02:46 AM
Solution@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.