<div>
Try Trim<br />
<br />
Example:<br />
Trim(&quot;B2&quot;)
</div>


<div>
Sorry:<br />
Clean()<br />
Might work better for non-printable characters<br />
ex.:<br />
Clean(&quot;B2&quot;)
</div>


Sorry:
Clean()
Might work better for non-printable characters
ex.:
Clean("B2")

<div>
Great,<br />
<br />
Enjoy your weekend without invisible characters.<br />
;-)<br />
<br />
Jeff
</div>


Great,

Enjoy your weekend without invisible characters.
;-)

Jeff

<div>
<div class="content wysiwyg-content">
Please offer a way to remove any unseen characters in excel data so that when data is modified or queries are created, the data are as accurate as possible. <br />
<br />
Thank you.
</div>
</div>


Please offer a way to remove any unseen characters in excel data so that when data is modified or queries are created, the data are as accurate as possible. 

Thank you.

Access - Remove Spaces and &quot;Invisible&quot; Characters

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Access - Remove Spaces and &quot;Invisible&quot; Characters

Access - Remove Spaces and "Invisible" Characters