Microsoft Excel — Hard
Key points
- TEXTJOIN can handle a range of text strings, unlike CONCATENATE
- A specified delimiter is used in TEXTJOIN for joining text
- Empty cells can be ignored in TEXTJOIN
- CONCATENATE requires individual cell listing
Ready to go further?
Related questions