asked on Need to replace text to formulas
I have cells with 'counta(Ink Annotations!B5:b1000) and need to do a find and replace to end up with:
=counta(Ink Annotations!B5:b1000)
=counta(Ink Annotations!B5:b1000)
Microsoft ExcelMicrosoft Office
Last Comment
Rob Henson
Press Ctrl+H to open Find and Replace Window, in Find Waht box type ' and in Replace with box type = and click on Replace All.
ASKER
Thanks
You're welcome Alex!
Find and Replace annoyingly does not work when replacing an apostrophe at the beginning of a cell because Excel does not recognise it as being content of the cell.
To prove it, use =LEFT(A1,1) where A1 contains the text and the result will be c.
Likewise replacing counta with =counta does not work. You end up with '=counta
To prove it, use =LEFT(A1,1) where A1 contains the text and the result will be c.
Likewise replacing counta with =counta does not work. You end up with '=counta
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
in the first box:
counta
in the second box
=counta
replace all.