The data is all numbers, but each of the series of four cells does not necessarily have an entry in each cell.

Example:

• A B C D

1 1 12 5 2

2 2 6 7

3 3 4 10

I wish to concatenate the cells A1:D1 (or A2:D2, etc.), but using a / as a separator. If there is no number in a cell, I do not want the separator to appear.

This is the formula that I am using (Please note that this is simply copied directly from my sheet and does not follow the example above precisely)

=CONCATENATE("";$Calculations.U33;IF(ISBLANK($Calculations.V33);" ";"/"&Calculations.V33);IF(ISBLANK($Calculations.W33);" ";"/"&$Calculations.W33);IF(ISBLANK($Calculations.X33);" ";"/"&$Calculations.X33))

It concatenates well enough, but I still get all of the separators.

Obviously something is wrong, but I can't for the life of me figure it out.