<div>
hit ctrl+h<br />
<br />
in the first box:<br />
counta<br />
<br />
in the second box<br />
=counta<br />
<br />
replace all.
</div>


hit ctrl+h

in the first box:
counta

in the second box
=counta

replace all.

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


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.

<div>
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.<br />
<br />
To prove it, use =LEFT(A1,1) where A1 contains the text and the result will be c.<br />
<br />
Likewise replacing counta with =counta does not work. You end up with '=counta
</div>


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

<div>
<div class="content wysiwyg-content">
I have cells with 'counta(Ink Annotations!B5:b1000) and need to do a find and replace to end up with:<br />
=counta(Ink Annotations!B5:b1000)
</div>
</div>


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)

Need to replace text to formulas

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.