Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to read a string in excel and include the single quote
I have the following value in a cell:
'TEST14','TEST15','TEST16' When printing this value to a TXT file, I get: TEST14','TEST15','TEST16' How do I get to include the single quote that occurs in the beginning of the string to be included in the output? Please help. My code: Sub Testme Sheets("sheet01").Activate gOutfile = "c:/test.txt" Open gOutfile For Output As #1 For r = 1 To 30 xData = Cells(r, 1).Value Print #1, xData Next r End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup and using single quote | Excel Worksheet Functions | |||
Writing formula to include quote marks in result | Excel Worksheet Functions | |||
Remove single quote | Excel Worksheet Functions | |||
How can I get rid of the ' single quote sign in excel worksheet | Excel Worksheet Functions | |||
Removing single quote from an excel sheet | Excel Discussion (Misc queries) |