Remove this symbol "

[fredrerik84]

Hi I have quick question. Ive run into a problem I dont know how to remove this symbol from a string "

Ive tried this:

sTitle = Replace(sTitle, """, "")

Anyone know how I can replace this symbol with nothing ?

frederik

 

[Scott Huish]

You need another quote:

stitle = Replace(stitle, """", "")

 

[ranman256]

https://www.extendoffice.com/documents/excel/3160-excel-remove-quotes-from-cell.html

 

[mikerickson]

sTitle = Replace(sTitle, Chr(34), vbNullString)

" removed

 

[fredrerik84]

You need another quote:

stitle = Replace(stitle, """", "")

It didnt seam to work , are you sure that is correct ? maybe there is something else wrong?

edit tested and it works the other way around but for some reason it does not work on this string ?

[TABLE="width: 39"]
<tbody>[TR]
  [TD="class: xl91, width: 39"]"5.8"[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

It didnt seam to work , are you sure that is correct ? maybe there is something else wrong?

Scott gave you the correct code to remove quote marks (ASCII code 34) from a given text string. If it did not work for you, perhaps your quote marks are "stylized" one like you get when you copy text from Microsoft Word. Copy one of them to a cell by itself and put this formula in another cell...

=CODE(A1)

change the A1 to the cell you put the copy of the quote mark into. If that formula does not display 34, then you do not have normal quote marks.

 

[fredrerik84]

this was a huge pain to remove :/

Its not styled,, Its scraped from a web pages and it looks like multilinetext in one cell but in not able to split it with this code:

sTitle = Trim(Split(sTitle, vbCrLf)(1))

This is how it looks like after ctr + v: (3 rows into one cell in excel)
[TABLE="width: 43"]
<tbody>[TR]
[TD="class: xl91, width: 43"] 5.8[/TD]
[/TR]
</tbody>[/TABLE]


Edit: Im able to get just the number using this code

sTitle = Mid(sTitle, 2)

however this is not the best as most result comes out without this error

 

[fredrerik84]

Here is a small sample that shows how it is stored in excel

<a href=http://www.filedropper.com/strangebehavior><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br /><div style=font-size:9px;font-family:Arial, Helvetica, sans-serif;width:127px;font-color:#44a854;> <a href=http://www.filedropper.com >share files free</a></div>

 

[Scott Huish]

It's not CHR(13), it's CHR(10)

stitle = Replace(Range("A1"), vbLf, "")

 

[fredrerik84]

It's not CHR(13), it's CHR(10)

stitle = Replace(Range("A1"), vbLf, "")

Thanks alot buddy. this was really starting to confuse me, Like empty space nothing is something here

Glad to have it removed