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
The Text Functions category covers essential Excel functions for manipulating and analyzing text data. Learn how to extract, format, split, and clean text using LEFT, RIGHT, MID, TEXT, CONCAT, TEXTJOIN, FIND, SEARCH, and more. Whether you’re working with names, addresses, or structured data, these functions help automate text processing and improve data accuracy. Explore our tutorials, examples, and tips to master text handling in Excel!
Split your text on a delimiter – TEXTSPLIT Function
Discover the new TEXTSPLIT function in Excel 365 that allows you to split cell content using specified delimiters easily.
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 (12)
- 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 (19)
- Lookup functions (14)
- Manage data (18)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (6)
- Shortcuts (5)
- Statistical functions (25)
- Text functions (18)
- Tips and Tricks (21)
