How can I extract text to the right of a space in Excel?

By /

To extract text to the right of a space in Excel, you can use the RIGHT function combined with the FIND function. The FIND function will locate the position of the space in the text, and the RIGHT function will extract the text to the right of that space. This can be useful for separating first and last names, or for extracting specific information from a larger string of text. By using these functions in combination, you can easily and accurately extract the desired text from your Excel data.

Excel: Extract Text Right of Space

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:

Excel text right of space

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 .

Additional Resources

The following tutorials explain how to perform other common operations in Excel:

x

Related terms:

  1. Excel: Extract Date from Text String How do i extract a date from a text string?
  2. Excel: Extract Text Right of Space
  3. How do I extract text after the last space in a cell in Excel?
  4. How do I extract text between second and third space in Excel?
  5. How do I use LEFT to extract text before space in Google Sheets?
  6. How can I split text by space in Excel?
  7. Split Text by Space in Excel (With Example)
  8. Excel: Add Space Between Text in a Cell
  9. Excel: Extract Characters from Right Until Space
  10. How do I extract a string before a space in R?