Table of Contents
Excel is an incredibly powerful tool that can be used for a wide variety of applications. One of the most useful features of Excel is its ability to extract text from a variety of sources. In particular, the ability to extract text right of a space can be incredibly helpful when dealing with large data sets. This feature can help to quickly and accurately parse out information from long strings of text, making data more organized and easier to analyze. Excel’s powerful text extraction features can also help to automate tasks, saving time and effort. This article will discuss the importance of Excel’s ability to extract text right of a space and how it can benefit users.
You can use the following formula to extract all of the text to the right of a space in some cell in Excel:
=TEXTAFTER(A2, " ")
This particular formula extracts all of the text in cell A2 that occurs after the first space is encountered.
The following example shows how to use this formula in practice.
Example: Extract Text Right of Space in Excel
Suppose we have the following list in Excel that provides a description of different basketball players including their team, position, and rating:
Now suppose that we would like to extract only the text in each cell to the right of the first space.
To do so, we can type the following formula into cell B2:
=TEXTAFTER(A2, " ")
We can then click and drag this formula down to each remaining cell in column B:
Column B now displays only the text to the right of the first space of each cell in column A.
If you would instead like to display all text to the right of the last space of each cell in column A, you could type the following formula into cell B2 instead:
=TEXTAFTER(A2, " ", -1)
We can then click and drag this formula down to each remaining cell in column B:
Note that the third argument in the TEXTAFTER function specifies the instance of the delimiter to extract the text after.
By using -1 we specify that all text should be extracted to the right of the last instance of a space.
Note: You can find the complete documentation for the TEXTAFTER function .