Hello,
I have minor problem with combining cells. In my document i have cells which contain informations in beetwen 1-3 cells. When I use formula =(B2&","&C2&","&D2) (etc) 0 is being displayed in the formula where there is noting in used cell.
For example
http://www.novumedukacja.pl/files/distributors/photos_nw_1600x_1200/6303370.jpg,0,0 |
Is it possible to remove these 0,0 without doing it manually? (i have over 1000 cells). Or is there formula which do it automatically?
Cheers!