Jul 28 2020 11:36 AM - edited Jul 28 2020 11:39 AM
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 formula for cells with only manual inputs. I have attached a picture below of my situation.
- in the below I'm looking to remove the "*1.173)/1.173"
Jul 28 2020 12:01 PM
Jul 28 2020 12:05 PM
Jul 28 2020 12:11 PM
Solution
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 )
Jul 28 2020 12:16 PM
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
Jul 28 2020 12:40 PM
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.
Jul 28 2020 01:34 PM
Jul 28 2020 12:11 PM
Solution
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 )