Impossible replace "" double quotes

[Nelson78]

Hello everybody.

I'm importing datas from a website.

The datas have "" double quotes, it seems they are normally invisible (I can see them only copying an pasting in a notepad).

How can I remove them?

I've already tried different ways, unsuccessfully (for example):

Dim c As Range
    
   For Each c In Worksheets("Alpha").Range("E2:E55")
            c = Replace(c, """", "")

Next

Dim c As Range
    
   For Each c In Worksheets("Alpha").Range("E2:E55")
            c = Replace(c, Chr(34), "")

Next

 

[Joe4]

Have you confirmed that they are Chr(34), or are you just guessing?
When they appear in a cell, are they the ONLY thing in the cell, or are they combined with other data in the cell?
If the later, do they tend to appear at the beginning or end of the cell?

 

[Nelson78]

Ascii code table:

https://ascii.cl/


The value expected is the one I see on the web site (10 characters):
P275255439

When imported in Excel, if I copy and paste it on notepad, this is the result:

https://ibb.co/mWuySc

16 characters instead of 10.

I succeeded remove spaces with:

For Each c In Worksheets("Alpha").Range("E2:E55")
        c = Replace(c, " ", "")
    Next