User Profile
lsmithop
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
remove a ' to convert a comment to a formula in excel
I routinely stick a ' in front of a formula to stop Excel from complaining/editing my text while I edit it to be the formula I want. Then I remove the ' to convert the cell back to a live forumula. Well, today I needed to edit 1500 cells to contain the formulas I needed, so i edited all my = to be '=, adjusted all my formulas, and now I cannot figure out how to use Excel's Replace (or even Find!!) to convert them back. Oops! If I search for '= (just apostrophe equals) I get "We couldn't find what you're looking for". I have tried varying all the options, tried using ^? to avoid ' in case that's some special character, etc. I attached a trivial case which shows the search failing... Can someone save my 1500 formulas? How can I rescue them? Thanks! LenSolved3.1KViews0likes11Comments
Groups
Recent Blog Articles
No content to show