My Excel install is version 15.27. I have seen people say that I need to hit CTRL+SHIFT+Enter or CMD+SHIFT+Enter but neither of these do anything at all.
. Range – This is range of values which we want to concatenate together.
Delimiter – This is the delimiter value which we want to use to separate values by in our concatenation. Use empty quotes if we don’t want to use a delimiter. ConditionRange – This is the range of values which we will use to test whether or not to concatenate an item from our Range. Condition – This is the condition to test. What It Does This formula will conditionally concatenate a range based on a criteria in another range.
How It Works.