You can combine two text cells in Excel using the TEXTJOIN function. No matter whether you want to join two or more than two cells, you can use this function to get the job done.

Excel doesn't offer a one-click solution if you need text in sentence case (where only the first letter of the sentence is capitalized). But don’t worry! You can create a custom formula using the LEFT ...

2. Sort Function. The Sort Excel function is a powerful tool for organizing and arranging your data in a meaningful order. Whether you need to sort numbers, text, or dates, this function has you ...

$2, $1 tells Excel that I want to reverse the order of those two strings of text, separated by a comma and a space. If I didn't include the dollar symbols, Excel would simply return "2, 1" as the ...

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

This newish function is available in Microsoft 365 and Excel 2021, and Excel for the web. For your convenience, you can download the demonstration .xlsx file .

Learn how to create a fixed formula using the FIXED function, which is a Text function, in Microsoft Excel. There are 3 ways.