I have an excel 2013 spread sheet with column of referenced cells and I did a search and replace of = to '= to change it to a text cells. I then did a copy and transpose paste to a row.. I then need to change the cells back to formula. I have tried the Find and Replace to change '= back to just = but excel says it cannot find it? This works on other sheets but not this one eg I want to change '='REFERENCE ONLY'!K109 to ='REFERENCE ONLY'!K109 Any suggestions??
Thanks
Bookmarks