Replace invisible symbol

Getting Started
1

Hi,

i have a invisible symbol in a textfile, problably a “non-breaking-sign” → \x{A0}

i want to replace this at import, how can I search for this “\x{A0}”?

Marco

2

I think it is Chr(160), Non Breaking Space (Sticky Space).

It may or not be a gremlin (this depends on where it is in the text and the grammar rules for your country)

Google string to use for more details (and values):
unicode non breaking space

I forgot the code to Replace one string with another…

String Replace

Syntax:
Replace(oldString As String, newString As String) As String

Sample code in the documentation (link above)

3

thank you!

I always tried to search for that unicode string…