I have a spread sheet that i use for job costing and estimating. I work in the concrete construction industry so i deal a lot with cubit yards and square and linear feet.
I have a cell that calculates the cubic yardage of a 4" thick slab at "x" square feet which is in another cell. We buy the concrete material by the yard but we charge by the square footage.
I want to be able to have a cell that says say "1500 Sq Ft" and a cell that says "$4.00". From this i want to be able to use just the 1500 times the $4.00 to equal $6000 in another cell. but i get error messages because of the text string "Sq Ft" in the first cell.
Is there a way to use this without separating into 2 cells, perhaps a way to take just the numeric part of the cell to be used in the formula?
Thanks
Aric
I have a cell that calculates the cubic yardage of a 4" thick slab at "x" square feet which is in another cell. We buy the concrete material by the yard but we charge by the square footage.
I want to be able to have a cell that says say "1500 Sq Ft" and a cell that says "$4.00". From this i want to be able to use just the 1500 times the $4.00 to equal $6000 in another cell. but i get error messages because of the text string "Sq Ft" in the first cell.
Is there a way to use this without separating into 2 cells, perhaps a way to take just the numeric part of the cell to be used in the formula?
Thanks
Aric