Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel comma quote
Is there a way to select a column of ID numbers in an Excel (2002)
column and save it to a text file or clipboard with comma quote delimiters? 0000031814 0000044857 0000015098 0000043186 0000111012 0000017184 becomes "0000031814","0000044857","0000015098", "0000043186","0000111012","0000017184" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel comma quote
Hi,
One suggestion will be to do Edit/Copy and then Edit/PasteSpecial/Transpose. This will help you transform the column of cells to a row of cells. Then delete the column of cells and export to a CSV format. (This option is available when you save the file by using Save As on an existing file.) Unfortunately this will still not enclose the numbers in double quotes. Alok " wrote: Is there a way to select a column of ID numbers in an Excel (2002) column and save it to a text file or clipboard with comma quote delimiters? 0000031814 0000044857 0000015098 0000043186 0000111012 0000017184 becomes "0000031814","0000044857","0000015098", "0000043186","0000111012","0000017184" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel comma quote
Does this get you started:
Sub Test() Dim i As Integer Dim strList As String For i = 1 To Range("MyRange").Count strList = strList & """" & Range("MyRange")(i).Text & """, " Next i strList = Left(strList, Len(strList) - 2) MsgBox strList End Sub I tested this on your short list and it produced the correct string. However there may be a limit to the length of the string (max number of characters) Don't know if this will work for you. " wrote: Is there a way to select a column of ID numbers in an Excel (2002) column and save it to a text file or clipboard with comma quote delimiters? 0000031814 0000044857 0000015098 0000043186 0000111012 0000017184 becomes "0000031814","0000044857","0000015098", "0000043186","0000111012","0000017184" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CANNOT Import comma delimted, quote qualifed text file into Excel. | Excel Discussion (Misc queries) | |||
adding a single quote and comma to every cell in Excel | Excel Programming | |||
how do I create comma and double quote delimited file | Excel Discussion (Misc queries) | |||
Excel How do I create a comma delineated xls file to a comma delineated. | Excel Discussion (Misc queries) | |||
Typing a quote character Vs pasting a quote character= whathappens to the resulting CSV? Interesting!! | Excel Programming |