Excel Pro Tips
Combine Multiple Cells into One Separated by Comma in Excel
Learn how to combine multiple cells into one in Excel, separated by commas, using CONCAT, TEXTJOIN, ampersand (&) and VBA code.
Read article
Concatenate
13 lessons in order
Excel Pro Tips
How to Merge Cells Vertically Without Losing Data in Excel
Learn how to merge cells vertically in Excel without losing data using Justify, CONCATENATE, TEXTJOIN, ampersand (&), or a VBA macro.
Read article
![[Solved] CONCATENATE Function in Excel Not Working](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-concatenate-excel-not-working-01f51cea.webp)
Excel Pro Tips
[Solved] CONCATENATE Function in Excel Not Working
Learn why the CONCATENATE function in Excel may not work—due to text formatting, formula display mode, range issues, or using CONCAT instead.
Read article
Excel Pro Tips
How to Add a Comma Between Names in Excel (8 Different Ways)
Learn how to add a comma between names in Excel using Flash Fill, SUBSTITUTE, TEXTJOIN, CONCATENATE, Power Query, and VBA.
Read article
Excel Pro Tips
How to Add Text to Beginning of Cell in Excel (7 Easy Methods)
Learn how to add text to the beginning of a cell in Excel using formulas, Flash Fill, custom formatting, or VBA for quick prefix insertion.
Read article
Excel Pro Tips
How to Combine Text and Numbers in Excel (6 Suitable Ways)
Learn how to combine text and numbers in Excel using formulas, VBA, and Power Query for clean, dynamic, and well-formatted results.
Read article
Excel Pro Tips
How to Combine Two Formulas in Excel (5 Effective Ways)
Learn 5 easy ways to combine formulas in Excel, from using & and CONCAT to advanced techniques like INDEX-MATCH and nested IF statements.
Read article
Excel Pro Tips
How To Write Text And Formula in the Same Cell in Excel
Learn how to combine text and formulas in the same Excel cell using &, CONCAT, TEXTJOIN, VBA, Power Query, and IF functions.
Read article
Excel Pro Tips
How to Concatenate String and Integer in Excel Using VBA
Learn how to concatenate string and integer in Excel using VBA with ampersand and addition operators easily.
Read article
Excel Pro Tips
How to Bold Text in a Concatenate Formula in Excel
Learn how to bold text in a concatenate formula in Excel using VBA to format specific words or the entire result easily.
Read article
Excel Pro Tips
How to Combine Date and Text in Excel (4 Suitable Methods)
Learn how to combine date and text in Excel using CONCAT, ampersand, TODAY, and TEXTJOIN functions with clear examples.
Read article
Excel Pro Tips
How to Add Text to Multiple Cells in Excel (8 Different Ways)
Learn how to add text to multiple cells in Excel using formulas, Flash Fill, REPLACE, SUBSTITUTE, and VBA methods easily.
Read article
Excel Pro Tips
How to Concatenate with a Line Break in Excel
Learn how to concatenate with a line break in Excel using Ampersand and CHAR, CONCAT, TEXTJOIN, or VBA for clean multi-line results.
Read article