how to prevent blank cell copied when combining cells?

V

Vicneswari Murugan

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?
 
D

Dave Peterson

=if(a1="","",a1&" ")&if(b1="","",b1&" ")&c1
It kind of sounds like you were separating the cells with space characters.

If A1, B1, C1 all contained words with no spaces:
=TRIM(A1&" "&B1&" "&C1)
 
Top