View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mocha99 mocha99 is offline
external usenet poster
 
Posts: 3
Default Transforming data in column into a linear text string

Hi all,

my data in column A is like

cat
dog
apple

How can I copy that data into a string like "cat,dog,apple" without
having to manually remove the CR/LF and add the comma between the words?

I.E. how can I transform those rows into a single text string?


thanks so much