Manipulate Text with Functions

The text functions in Excel can be found in Excel by clicking the Text command button on the Formulas tab on the Ribbon. The drop-down menu lists all the text functions in Excel. If you work with Excel extensively, there are going to be occasions when you would need to use functions to manipulate text, especially when you work with data imported from other programs.

Tip : The Flash Fill command on the Home tab enables you to automatically perform many text manipulation tasks for which you would previously use functions. To learn more about Flash Fill, see my book Excel 2019 Basics .