View Single Post
  #1   Report Post  
Vicneswari Murugan
 
Posts: n/a
Default how to prevent blank cell copied when combining cells?

I've tried to combine data from few cells using "CONCATENATE" function. But,
when a cell is blank, a blank appears in the result. How to prevent this
blank?