© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
A. MurrayAdvanced Excel Formulashttps://doi.org/10.1007/978-1-4842-7125-4_5

5. Manipulating Text

Alan Murray1  
(1)
IPSWICH, UK
 

I have always enjoyed using formulas to manipulate text in Excel. Solving the puzzle of extracting, joining, and shaping text to our requirements is very exciting. They are some of my most enjoyable formulas to use and teach.

Excel contains over 30 functions for manipulating text. We will cover many of the most useful text functions in this chapter. These include LEFT, TEXT, TRIM, FIND, SUBSTITUTE, TEXTJOIN, and many more. We will also cover the new text functions released in 2022 – TEXTAFTER, TEXTBEFORE, and TEXTSPLIT.

In this chapter, ...

Get Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial