SOLVED

Deleting a portion of a formula for entire column

Occasional Contributor

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 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"

6 Replies

Perhaps Ctrl+H

and Replace All

Betreff: Deleting a portion of a formula for entire column

There are many paths that lead to Rome.
I tried to describe one of these ways here.

Go to

Start
Search and find
Replace
Search for: * 1.173) /1.173
Replace with: "what you want"
Press Find All and then Replace All.
Please specify the desired options beforehand (Button Options).

If the answer helped you, then please tick the correct answer so that others can also find out from it, a little like would also be good

Nikolino
I know I don't know anything (Socrates)
Best Response confirmed by Zmicrosoft (Occasional Contributor)
Solution

Re: 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.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 )

Re: Deleting a portion of a formula for entire column

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

Re: Deleting a portion of a formula for entire column

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.

Re: Deleting a portion of a formula for entire column

``=INDEX(\$11:\$11,1,ROW()-ROW(\$F\$11)+COLUMN(\$F\$11))``