sharad.sony
11-02-2016, 09:19 AM
I have an excel sheet and cell B2 I declare as integer.
I wish that if the cell b2 value is 3, cell b3 to d3 concatenate with ";" like concatenate(b3;c3;d3) and put this concatenated value to cell b4.
if the cell b2 value is 5, cell b3 to f3 concatenate with ";" like concatenate(b3;c3;d3;e3;f3) and put this concatenated value to cell b4.
Please help.
I wish that if the cell b2 value is 3, cell b3 to d3 concatenate with ";" like concatenate(b3;c3;d3) and put this concatenated value to cell b4.
if the cell b2 value is 5, cell b3 to f3 concatenate with ";" like concatenate(b3;c3;d3;e3;f3) and put this concatenated value to cell b4.
Please help.