Hello All,
I have a problem for which I need the solution ASAP.
I have values in 4 cells and I want to concatenate them with char(10) but skip if they are blank and just concatenate the cells which are not blank.
For Example,
=CONCATENATE(S3,char(10),S4,char(10),S5,char(10),S6) this works but if S4 is blank, it will still execute char(10) after S4 and I don't want that.
Please let me know if you have any solution to this problem.
Thank you in advance.
CP
Bookmarks