View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
stetka stetka is offline
external usenet poster
 
Posts: 6
Default Consolidate multiple cells into one

How would I consolidate multiple cells(more than two) into one cell. I used
concatenate but would like to be able to select all applicable cells at once
instead of keying in each cell number.