Forum Discussion
Solved
Deleting a portion of a formula for entire column
Hi, I'm trying to figure out how to delete a portion of a formula for a column of a table. I know how to change the value of the cells by paste special, but is there a shortcut to delete parts of a ...
select cells containing those formulas
replace = with some other character ( not number ) for excample "|"
replace ~** with nothing ( empty )
replace |( with =for excample first cell:
original formula :
=((25.995+0.9)*1.173)/1.173after first replace :
|((25.995+0.9)*1.173)/1.173 ( no more formula, plain text )after second replace :
|((25.995+0.9)after third replace :
=(25.995+0.9) ( formula again )
By any chance would you also happen to know how to use data that is laid horizontally in a formula that is filled down throughout a column. Or put another way, I want to fill a column with linked data from cells F11,G11,H11, etc rather than F11, F12, F13.
