View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default convert to cvs(,) from excel

Hi David

Thanks for your reply.

My question is

My Excel data file to convert Text CSV(,), I did following step: -
Save as - change file type to CSV (Comma delimited) and save. I
could not able to save as text file with comma. Only can save as Excel file
with column. I tried to copy & paste on notepad. I could able to copy with
space instead of comma. Pls help me to advise.

Thanks
JOHN

"David Biddulph" wrote:

Perhaps you don't mean CVS, but CSV (Comma Separated Variables)?

Yours is another of those posts which expects a certain clairvoyant ability
from readers of this group. You say "I could not able to", but if you want
us to help, you will have to give us a better idea of what the failure
symptoms are. What error message are you receiving? Did it produce a CSV
file? If so, did you look at the CSV text tile with a text editor (such as
Notepad) to see what was in it? If so, how did the contents differ from
what you were expecting?
--
David Biddulph

"John" wrote in message
...
I want to convert from excel to text file (CVS(,)). I use save as change to
CVS but I could not able to, Pls advise me !