Hello, I know it sound easy but I don't know why my brain got it stuck to work ..
I use this formula
but I try to make it ignore the blank cells and take the one after it without activating 2 (CHAR(10)) which will leave 2 or 3 lines empty instead of only 1
much appreciate your help
I use this formula
Excel Formula:
=C1&"-"&D1&CHAR(10)&B1&CHAR(10)&E1&CHAR(10)&J1&CHAR(10)&K1&CHAR(10)&"Details are attached"
much appreciate your help