Remove this symbol "

fredrerik84

Active Member
Joined
Feb 26, 2017
Messages
383
Hi I have quick question. Ive run into a problem I dont know how to remove this symbol from a string "

Ive tried this:
Code:
sTitle = Replace(sTitle, """, "")


Anyone know how I can replace this symbol with nothing ?

frederik
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
You need another quote:

Code:
stitle = Replace(stitle, """", "")
 
Upvote 0
You need another quote:

Code:
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 ?

Code:
[TABLE="width: 39"]
<tbody>[TR]
  [TD="class: xl91, width: 39"]"5.8"[/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited:
Upvote 0
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.
 
Upvote 0
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:

Rich (BB code):
sTitle = Trim(Split(sTitle, vbCrLf)(1))

This is how it looks like after ctr + v: (3 rows into one cell in excel)
5.8

<tbody>
</tbody>


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

Rich (BB code):
sTitle = Mid(sTitle, 2)
however this is not the best as most result comes out without this error
 
Last edited:
Upvote 0
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>
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top