Build Email Addresses from First and Last Name in Excel
Build firstname.lastname@company.com for a whole staff list with one Excel formula, the short version with LEFT, or Flash Fill with no formula at all.
TRIM
The TRIM function of Excel
Clean up your Excel data with the TRIM function. Learn how to remove extra spaces before and after strings to ensure data accuracy.
Count Words in an Excel cell
Want to count words in Excel? Check out these two techniques using the TEXTSPLIT function and the COUNTA function.
Categories
- AI & Excel (3)
- Conditional (13)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (12)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (13)
- Excel Tutorial (16)
- Expert (26)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (19)
- Lookup functions (14)
- Manage data (18)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (6)
- Quiz Premium (7)
- Shortcuts (5)
- Statistical functions (27)
- Text functions (21)
- Tips and Tricks (22)
