Thread: Concate a range ignoreing blank cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
  
Posts: 141
Default Concate a range ignoreing blank cells
Is it possible to concate acroos a rage ignoring any blank values in cells,

for example I wold like to concate A1 to A6 but if there is no value in A4
ignore that cell

Thanks


Reply With QuoteReply With Quote