please give sample to understand better

"Vicneswari Murugan" wrote:

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?