Text Functions Articles

Articles tagged Text Functions, including related tutorials, examples, and walkthroughs.

2 articles

2026-10-02

How to Split First and Last Names in Excel

Split names into columns with TEXTSPLIT, TEXTBEFORE, TEXTAFTER, or Text to Columns. Handle extra spaces, single names, and middle names....

#Excel#text functions#data cleanup

How to Change Case in Excel: Uppercase, Lowercase, and Proper Case

Learn how to change case in Excel with UPPER, LOWER, PROPER, Flash Fill, and Paste Special so you can safely replace text values....

#formulas#data cleanup#text functions

9 min read

Read Article

About Excel Semi Pro

Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.