I am looking to take a simple text joining formula like =CONCATENATE(A1,B1,C1), where A1 is "John Z.", B1 is "high score is", and C1 is "92". The result of that formula would be: John Z high score is 92.
I've been researching this question for the better part of an hour and haven't found a non-VBA solution, but since the last time it was addressed in these forums was ~5 years ago, I wanted to try again to see if maybe some functionality has slipped in that wasn't there before.
I've been researching this question for the better part of an hour and haven't found a non-VBA solution, but since the last time it was addressed in these forums was ~5 years ago, I wanted to try again to see if maybe some functionality has slipped in that wasn't there before.