VBA Remove hidden quotes in one cell

[rplohocky]

Hello,
I am trying to find a way to use VBA to remove these hidden quotes in front and end of a few words in one cell (B1). Can someone please pass on a way to delete or remove the quotes just in one cell?

Thank you!

 

[Logit]

.
This was a very interesting subject. I have never experienced 'invisible' quote marks. At first I thought of using the ASCII symbols but when keying it in, the quotes are visible.

I would still love to download an example of what you dealt with (even though you've found the answer for correction) and if someone could explain where the 'invisible quote marks' come from / are generated ?

Glad you found your answer !

 

[Fluff]

.
I would still love to download an example of what you dealt with (even though you've found the answer for correction)

Agreed, because character 73 is I, which means my suggestion in post#8 isn't seeing the hidden character either

 

[Fluff]

On second thoughts, is the file a csv or txt file?

 

[rplohocky]

.
This was a very interesting subject. I have never experienced 'invisible' quote marks. At first I thought of using the ASCII symbols but when keying it in, the quotes are visible.

I would still love to download an example of what you dealt with (even though you've found the answer for correction) and if someone could explain where the 'invisible quote marks' come from / are generated ?

Glad you found your answer !

Hello Logit,
I could send you a copy of the workbook with the quote issue, but how is that done in the forum?

 

[Logit]

This Forum doesn't have that option. You'd need to post to Dropbox or Google or something similar.