CONCAT vs CONCATENATE in Excel: What Actually Changed
CONCAT accepts a whole range, CONCATENATE needs every cell one by one. See what changed, which one to use, and the Excel version trap.
CONCAT
CONCAT vs TEXTJOIN in Excel: Which One Should You Use?
CONCAT glues cells together, TEXTJOIN adds a separator and skips the empty ones. See the difference in one table, then practise with a free exercise.
Categories
- AI & Excel (3)
- Conditional (13)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (12)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (13)
- Excel Tutorial (16)
- Expert (26)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (19)
- Lookup functions (14)
- Manage data (18)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (6)
- Quiz Premium (7)
- Shortcuts (5)
- Statistical functions (27)
- Text functions (21)
- Tips and Tricks (22)
