Here is another example.
//Ola
A95: =A2&""&StringConcat("; ";IF(ISTEXT(C2:C16);C2:C16;""))
The formula has to be confirmed by Ctrl+Shift+Enter, not just Enter.
Your instruction: "What I am trying to accomplish is in cell a95 ... i want to combine all of the descriptions from cells c2:c16 seperated by a ;"
Bookmarks