Excel Articles

Articles tagged Excel, including related tutorials, examples, and walkthroughs.

3 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 Delete Blank Rows in Excel Safely

Delete completely blank rows in Excel with a helper column and filter. Keep partial records, formulas returning empty text, and cells containing spaces....

#Excel#Data cleanup#Excel Tables

Excel IF Cell Contains Text: Formulas and Examples

Use IF with SEARCH, FIND, or COUNTIF to test whether an Excel cell contains text, with case-sensitive, multi-word, and blank-input examples....

#Excel#IF function#text formulas

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.