If you have Excel 2019 or Excel 365, you can use the function TEXTJOIN to quickly join text in one cell and separate the text with any delimiter, even if you have many rows or columns of data to join.

A combo box's autocomplete feature linked to a lookup function creates a flexible search tool.

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.

What is InputBox? VBA’s InputBox function is one of the most helpful functions you’ll use. It displays a dialog box and waits for the user to enter content and then click a button to continue.

Perhaps Excel will create a built-in function to convert text to sentence case in the future, but until then, a formula will work. If you would like to follow along in building this formula, you can ...

Microsoft is adding a COPILOT function to Excel, letting you use natural language prompts inside formulas to analyze, summarize, and categorize data.