View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default how to export a column as text separated by comma?

Hi
You can do Edit, Find, Replace on the column to find " " (put a space
bar in the Find box) and replace with "," (put a , in the Replace
box).
regards
Paul

On Apr 18, 8: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.