I'll try to make this understandable!
I have a spreadsheet that lists items that are included in a 'basket'. Some 'baskets' have up to 36 items in it.
I need the items listed in ONE cell. Here is what I have done so far.
I used the concatenate command to attach each item together, separating them with a line break (html) because they will appear on a web page. I had to split this into 2 commands, and then have a 3rd that combined the 2 that were just created (since it exceeded the 30 limit).
Some of the baskets only contain 3 items, but the way I have written the formula, puts a break for each item even if it's nothing --
How can I tell the original formula to only include the item if one exists in the cell? In other words, if a cell is empty, enter nothing...
Does that make sense?
Thanks!
I have a spreadsheet that lists items that are included in a 'basket'. Some 'baskets' have up to 36 items in it.
I need the items listed in ONE cell. Here is what I have done so far.
I used the concatenate command to attach each item together, separating them with a line break (html) because they will appear on a web page. I had to split this into 2 commands, and then have a 3rd that combined the 2 that were just created (since it exceeded the 30 limit).
Some of the baskets only contain 3 items, but the way I have written the formula, puts a break for each item even if it's nothing --
How can I tell the original formula to only include the item if one exists in the cell? In other words, if a cell is empty, enter nothing...
Does that make sense?
Thanks!