View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default convert vertical to horizontal

Hi,
Highlight the range, copy,paste special, transpose

"Mona" wrote:

I see lots of post but not one I can use. I am looking for a "function" that
will take vertical data to horizontal. I don't want the copy,paste,
transpose please.

Example :
1
2
3
Results
1 2 3

thanks!