I have a column that consists of hard-coded cells as well as formulas. Based on whether a specific cell is either hard-coded or contains a formula, I want to display it in two separate new columns.

So far that's pretty easy, e.g. using Go to - Special. However I need to maintain the row, and that's where I'm stuck.


Use this guide. And just make the text you're looking for an '=' sign. The '=' will denote a formula.

Then apply the same rule to the rest of column.

You can then do the same and make the text not looking for an '=' sign.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.