Excel LEN Function Explained
Learn how to use the LEN function in Excel to count characters in a string, data validation, and conditional formatting.
Text functions
Capitalize the first letter in Excel (Camel Case)
Find out how to capitalize the first letter in Excel using three powerful tools: PROPER function, Power Query, and macros.
Title with Text and Date in the same cell
Learn how to use the TEXT function in Excel to format numbers and keep the desired number format inside a string.
Categories
- Conditional (11)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (11)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (15)
- Excel Tutorial (15)
- Expert (26)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (20)
- Lookup functions (14)
- Manage data (20)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (5)
- Shortcuts (5)
- Statistical functions (23)
- Text functions (17)
- Tips and Tricks (21)
