Excel TVExcelTV

Excel tutorialsAnalyticsTraining

Excel at Excel.

Tutorials, tips, and reviews for analysts and data pros — written by Excel obsessives, since 2014.

Browse all tutorialsRead course reviews
251+
Tutorials & tips
4
Buyer guides
12+
Years online
Excel Replace WildcardLatest
Excel Functions & Formulas

Excel Replace Wildcard

Read article →

Fresh from the blog

The latest

View all posts →
Excel Replace Carriage Return
Excel Functions & Formulas

Excel Replace Carriage Return: Streamline Data Cleaning

SUBSTITUTE(text, CHAR(10), ' ') replaces line breaks in cells with a space or other character — useful for cleaning multi-line text from imported sources.

Expert reviews

Vetted gear, courses & books.

Hand-picked recommendations refreshed for 2026. Some links are affiliates — purchases may earn the site a small commission at no extra cost to you.

Find what you need

Browse by topic

Quick wins

Excel tips & tricks

More tips →

Stay in the loop

Join the Excel TV community.

New tutorials, expert interviews, and Power Query deep-dives. Subscribe wherever you prefer.

Subscribe on YouTubeJoin the Facebook groupRSS feed