Strip out quotes

J

JoeBo

Is it possible to strip the quotes from a string value and declare the return
as an integer. ie.

make the string "1" = 1

I have tried replace but can't figure out the syntax to deal with the quotes.
 
W

Wayne Morgan

See if the Eval() function will do what you want.

Eval("1")

Also, you may find the data conversion functions helpful.

CInt()
CLng()
CDbl()
CSgl()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Export to PDF 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
VBA - exporting serial letters to single documents 0
Use Value of Dynamically Created Variable 5
Find/Replace MSWord wildcard characters from within Excel 6
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Using Excel to Separate info within a Cell 3

Top