Forum Discussion
Deleting a portion of a formula for entire column
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 )
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.173
after 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 )
When I tried to find and replace with the "*1.173)/1.173" replacing it with ), it deleted the entire cell formula replacing it with just a closed parenthesis, but what you said worked. Thanks
