I have a rows of formulas of 150 lines
ex: =Takeoff!B6*D7
=Takeoff!B54*D8
=Takeoff!B102*D9
I need to take off the *D7,*D8,etc is there a formula I can put in the find
and replace to do this easier than going to each cell and deleting it.
Or is there another way using Text replace item?

Thanks
david