View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Henry
 
Posts: n/a
Default how to combine text into a cell???

there are numbers 1 to 100 on conlumn A, like A1=1,A2=2,A3=3, so on. how can
I combine all of these numbers into one cell like 123456789101112....
I know I can use =A1&A2&A3
but it is just only good for combining few of data together, any one can
tell me a good way to do this???