Excel Pro Tips
How to Highlight Cells in Excel Based on Value (9 Examples)
Learn how to highlight cells in Excel based on value using rules for numbers, text, duplicates, averages, exact matches & multiple conditions.
Read article
Excel Pro Tips
555 articles
Excel Pro Tips
How to Apply Conditional Formatting to Blank Cells in Excel
Learn how to apply conditional formatting to blank cells in Excel using the built-in “Blanks” option, ISBLANK, OR, LEN functions & formulas.
Read article
Excel Pro Tips
How to Calculate Win-Loss Percentage in Excel (5 Easy Ways)
Learn how to calculate win-loss percentages in Excel using formulas, text-based data, sales stats, and even automate it with a VBA macro.
Read article
Excel Pro Tips
How to Undo Changes in Excel after Save and Close
Learn how to undo changes in Excel after saving and closing using AutoSave, backups, file history, and recovering unsaved versions.
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 Randomize a List of Names in Excel (6 Quick Methods)
Learn how to randomize a list of names in Excel using RAND, RANDBETWEEN, INDEX, SORTBY, CHOOSE, Power Query, and custom VBA for shuffling.
Read article
Excel Pro Tips
How to Randomly Select from a List in Excel (5 Useful Ways)
Learn how to randomly select from a list in Excel using Data Analysis, INDEX with RANDBETWEEN, RANDARRAY, RAND, and custom VBA macros.
Read article
Excel Pro Tips
How to Return Multiple Values Based on Single Criteria in Excel
Learn how to return multiple values based on single criteria in Excel using FILTER, INDEX, TEXTJOIN, Power Query, and custom VBA macros.
Read article
Excel Pro Tips
How to Return Row Number of Match in Excel (8 Suitable Ways)
Learn how to return the row number of a match in Excel using ROW, MATCH, INDEX, IF, TEXTJOIN, and VBA for single or multiple matches.
Read article
Excel Pro Tips
How to Put Comma Between Numbers in Excel (5 Simple Ways)
Learn how to insert commas in numbers in Excel with custom formatting, TEXT function, conditional IF, string functions &Comma Style button.
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 Convert Radians to Degrees in Excel (3 Easy Methods)
Learn how to convert radians to degrees in Excel using the DEGREES function, a manual PI-based formula, or a simple VBA macro.
Read article