How to Combine First and Last Name in Excel (5 Ways)

How to Combine First and Last Name in Excel (5 Ways)

Combine First and Last Names in Excel Using Formulas and Functions or Flash Fill by Avantix Learning Team | Updated June 28, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 and 365 (Windows) You can combine first and last name in Excel in several ways –...
How to Use the XLOOKUP Function in Excel (with Examples)

How to Use the XLOOKUP Function in Excel (with Examples)

Use the Excel XLOOKUP Function to Look Up Data (and Why It's Better than VLOOKUP) by Avantix Learning Team | Updated June 27, 2026 Applies to: Microsoft® Excel® 2021, 2024 and 365 (Windows) The XLOOKUP function is a replacement for Excel's traditional VLOOKUP function...
How to Remove Duplicates in Excel (3 Easy Ways)

How to Remove Duplicates in Excel (3 Easy Ways)

Quickly Find and Delete Duplicates in Excel Worksheets by Avantix Learning Team | Updated January 19, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 and 365 (Windows) You can remove duplicates in Excel in several ways. When you use the Remove Duplicates...
How to Combine Cells in Excel Using Concatenate (3 Ways)

How to Combine Cells in Excel Using Concatenate (3 Ways)

Combine Data in Cells Using the CONCATENATE Operator or Functions by Avantix Learning Team | Updated June 28, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 and 365 (Windows) You can combine the data from multiple cells into another cell using the...
How to Convert Text to Numbers in Excel (5 Ways)

How to Convert Text to Numbers in Excel (5 Ways)

5 Ways to Convert Numbers Stored as Text to Numbers in Excel by Avantix Learning Team | Updated June 26, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 and 365 (Windows) There are several ways to convert text to numbers in Microsoft Excel. When data is...

Pin It on Pinterest