String has quote by default. How to remove that quote from string?

Hi,

My string has charactes(alphabat + numeric). That string values will change in every row, and come from cell value in excel. And I want to find that value in another worksheet. It never find, while the same value available in another sheet. Through Watch window I found that string has quotes ( "RCTXB0180"), because it stored as String. While value in another sheet is without quote. Please guide How to remove that quote from string. Or any other way to find that value from range. I do not want to use "For and next " or Do loop, because I want that if string value not find on range, then a new line insert and put the value of string in that new line. I also tried Replace, but it would also not work

Alpha numeric values are strings and strings always show with quotes around them when you look at the values. The quotes are not actually part of the value. I doubt this is your problem, more likely you are getting into a case of case sensitivity RCTXB != RcTXB

In any case this sounds like and Excel VBA question and should be moved to the office section.

Thank you very much sir for your reply...!!!
But that is not case of case sensitivity. I know that quote is not a part of value, but when it looking the value in another worksheet, than it search with quote as i saw in watch window. Hence the value in excel another worksheet is not with quote so vba not recognize it as same value as string.

Excel has its own "hillbilly variant" format for cell contents.

It can do crazy things. If you try to stuff "123" into a cell via its automation interface it tends to coerce the value to some numeric type that it prefers (Double?).

The workaround is to assign "'123" (with an apostrophe) instead. That even works in the Excel sheet view manually. It will complain mildly (usually there is some visual indication that varies by Excel version) but it works.


In general Excel sucks. But it kind of has to. For its intended purpose it can be a great tool, but it should never be used as a datastore or publishing medium.

Code:

---


s = Replace$(s, """", "") ' Is that what you're looking for?


---

That assumes you're pulling the cell values into a VB6 string before you're processing them.

But if the value contains quotes it gets more complicated than that.

I think he's just lost trying to make sense of the Watch Window display.

Sir, Value don't have quotes. But when the value store in string then it has automatically have quotes.
Dim x as string
X= worksheet1. Range("e" & z)
Worksheet2. Range("e3:e"& v) .find(x)

Now sheet1 value is RCTX0180, but in watch window showing "RCTXB0180",which is understandable.but when string x value search between the range given, then it come nothing, while the same value available in given range. Because value stored in string with quotes and in worksheet cell contain the same value but without quote

I already tried that replace syntax many times but nothing change. It return with same value.

have you tried the parameters for find? lookAt should allow to specify xlPart that should find the value between the quotes