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!

Try

=IF(B2="","",B2)&"."&IF(C2="","",C2)&"."&IF(D2="","",D2)

It doesnt seem to work. I am working on Polish language but I changed it to English (US) in options to be sure. 

I am using Excel 2013. 

If you use comma as decimal separator and semi-colon as list separator, try

=JEELI(B2="";"";B2)&","&JEELI(C2="";"";C2)&","&JEELI(D2="";"";D2)

Formula keep on showing 0's. 

That's weird.

Could you create a stripped-down copy of the workbook (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as Microsoft OneDrive (https://onedrive.live.com), FileDropper (http://filedropper.com) or DropBox (https://www.dropbox.com). Then post a link to the uploaded and shared file here.

Or register at www.eileenslounge.com (it's free) and start a thread in the Excel forum. You can attach files up to 250 KB to a post there (zipped if necessary).

www dropbox.com/home?preview=Trial.xlsx, if its not working here is speedyshare mirror www speedy.sh/8EZqs/Trial.xlsx

Thanks, the 2nd link worked for me. There are no empty cells in the used range - there are some that contain 0 instead of a file path.

Here is a formula that should work:

=IF(B2=0,"",B2)&IF(C2=0,"",","&C2)&IF(D2=0,"",","&D2)

or in Polish:

=JEELI(B2=0;"";B2)&JEELI(C2=0;"";","&C2)&JEELI(D2=0;"";","&D2)

Thanks a lot mate, now its working 100% correctly. 

Have a nice day :).