View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andy Andy is offline
external usenet poster
 
Posts: 414
Default List of numbers seperated by a colon

I would like to transpose a vertical range of cells into a single cell so
that each number is seperated by a colon. Here is an example:
A B C
1 50 50:45:30
2 45
3 30

Thanks!