Combine text from two or more cells into one cell
How to combine text or data from two or more cells into one cell in Excel.
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters and when you're searching and replacing content. These can also be used in the Conditional Formatting rules that use the "Format cells that contain specific text" criteria.
Using IF with AND, OR, and NOT functions in Excel
Technical Details. Here are overviews of how to structure AND, OR and NOT functions individually. When you combine each one of them with an IF statement, they read like this: AND – =IF (AND (Something is True, Something else is True), Value if True, Value if False)
FILTER function - Microsoft Support
The FILTER function filters an array based on a Boolean (True/False) array. An array can be thought of as a row of values, a column of values, or a combination of rows and columns of values. In the example above, the source array for our FILTER formula is range A5:D20.
Combine text from two or more cells into one cell
How to combine text or data from two or more cells into one cell in Excel.
Using Flash Fill in Excel - Microsoft Support
Training video: AutoFill and FlashFill. Combine text from two or more cells into one cell. Have Excel automatically fill your data when it detects a pattern. For example, the months of the year, the days in a month, or a sequence of numbers.
Insert subtotals in a list of data in a worksheet - Microsoft Support
How to use the Subtotal command in Excel to calculate subtotals and grand totals in a list.
Use the SUM function to sum numbers in a range
You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM (A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.
Basic tasks in Excel - Microsoft Support
The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text, or formulas. You put data in your cells and group them in rows and columns. That allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts.
Add or subtract time - Microsoft Support
Let's say that you need to add two different time values together to get a total. Or, you need to subtract one time value from another to get the total time spent working on a project. As you'll see in the sections below, Excel makes it easy to add or subtract time. Windows Web.
Date and time functions (reference) - Microsoft Support
Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.