<div>
Try something like this.<br />

<pre><code class="code-10 nolinks" id="code-20-41447458-1"><span>Sub DeleteApostrophes()</span>
<span>Dim rCell As Range</span>
<span></span>
<span>For Each rCell In ActiveSheet.UsedRange</span>
<span>If rCell.PrefixCharacter = &quot;'&quot; Then</span>
<span>rCell.Value = rCell.Value</span>
<span>End If</span>
<span>Next rCell</span>
<span></span>
<span>End Sub</span>
</code></pre>
</div>


<div>
DougDodge<br />
<br />
in reality those are not apostrophies, although they look like apostrophies.<br />
<br />
you can fix this without any macro select all of your data by Control + A and then &nbsp;as shown in below screenshot click on clear formatting.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/02_w06/1079430/2016-02-03-19_03_18-New-notification.png" target="_blank" title="2016-02-03-19_03_18-New-notification.png (90 KB)"><img alt="2016-02-03-19_03_18-New-notification.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2016/02_w06/800_1079430/2016-02-03-19_03_18-New-notification.png" /></a>
</div>


2016-02-03-19_03_18-New-notification.png

<div>
Well done Professor.<br />
Sometimes Excel inbuilt features do wonders. Very clever one.
</div>


<div>
This works perfectly, thank you.
</div>


<div>
DougDodge<br />
&nbsp;I am okay with that solution you selected as accepted , out of curiosity did that code really work? Becuase the file you uploaded had no apostrophes but it was just a format that needed clearance of format .
</div>


<div>
Yes, the code really did work.
</div>


<div>
As ProfessorJimJam pointed out, they really are not apostrophes, but they are there if you click in any given cell.
</div>


<div>
@DougDodge<br />
As the solution provided by Professor also works and simplest to adopt, please take a moment to use Request Attention to split the points. I will welcome if you do so.
</div>


<div>
Sktneer,<br />
<br />
Please :-) it is alright <br />
<br />
No need to split points. Your solution works better for Doug , so that is what matters <br />
<br />
<br />
Cheers<br />
JJ
</div>


<div>
<div class="content wysiwyg-content">
I receive many dumps from a Database that has every cell with a leading apostrophe. The attached sheet has a macro that when run will remove the apostrophe from cells that contain dates or numbers, but will not remove the preceding apostrophe from text. I hope to get the macro modified to remove all preceding apostrophes.<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/02_w06/1079415/Test-Worksheet---Copy.xlsm" target="_blank" class="file-inline" title="Worksheet with Macro (435 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Test-Worksheet---Copy.xlsm</a>
</div>
</div>


Test-Worksheet---Copy.xlsm

I receive many dumps from a Database that has every cell with a leading apostrophe. The attached sheet has a macro that when run will remove the apostrophe from cells that contain dates or numbers, but will not remove the preceding apostrophe from text. I hope to get the macro modified to remove all preceding apostrophes.

Remove preceding apostrophes.....

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

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