View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default how to export a column as text separated by comma?

Please re-read the request. Your answer isn't consistant with the request.

"Ken" wrote:

Dino

Use text to columns, with fixed width, separate each character. Then
save as a csv file. When you open it in a text editor it may have
some trailing commas if all the strings in your column do not have the
same number of characters. In the text editor you should be able to
replace ,, wtih nothing.

Good luck.

Ken
Norfolk, Va

On Apr 18, 3:45 am, wrote:
Hello I am new in excel 2007,
how i can export a column of one excel file into text objects
separated by comma?
For example if i have:
column1 = a b c d e f

how i can obtain a text like this?

data = a,b,c,d,e,f

Thanks, you can contact me also by email.
Dino.