Forum Discussion

Copper Contributor

Jul 28, 2020

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

excel

Formulas and Functions

Olli Haavisto
Jul 28, 2020
Zmicrosoft

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 )

NikolinoDE

Gold Contributor

Jul 28, 2020

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)