View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Seldonian Crisis[_2_] Seldonian Crisis[_2_] is offline
external usenet poster
 
Posts: 2
Default Concatenate large numbers of cells

I've got to concatenate 416 cells within a row, the resulting text also needs
to be split by commas . do i have to manually write out
CONCATENATE(A1,CHAR(44),B1,CHAR(44),C1... etc or is there a way of speeding
this up?