Resolved: Working with text in Excel
This is just a comment
I'd prefer write the last formula as below
=B5&", "&C5
We also have the TEXTJOIN function in current version of Excel which works perfectly for this kind of exercise: =TEXTJOIN(",",TRUE,B5,C5).
1 answers ( 1 marked as helpful)
Hey Occelus,
Sounds good. There are many ways to obtain the same result. As long as it works - feel free to stick to your preferred method.
Best,
Ned
Submit an answer
