How To Pick Last Word Or First Word From A Cell In Excel?
Many times, we have bulk data from which we have to extract a particular word from a cell in Excel.
Here are given two useful tips to extract last and first word in Google Sheets or in Excel to save your time and increase the productivity working on Excel.
Here’s the formula in Excel to extract the last and first word to another cell.
1. Syntax For Picking Last Word From A Cell
Excel Formula:
=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",100)),100)
RIGHT: Returns the last word from a cell.
Example: Cell A2 contains the name “SAJID SHARAFAT KHAN”
= TRIM(RIGHT(SUBSTITUTE(A2,” “,REPT(” “,100)),100) function will return “KHAN” which is the last word of the given name.
See screenshot for easy to understand for using syntax to move the last word to another cell.
2. Syntax For Pick First Word From A Cell
Excel formula:
=TRIM(LEFT(SUBSTITUTE(A2," ",REPT(" ",100)),100))
LEFT: Return the first word in a text string based.
Example: Cell A2 contains the name “SAJID SHARAFAT KHAN”
=TRIM(LEFT(SUBSTITUTE(A2,” “,REPT(” “,100)),100)) function will return “SAJID” which is the first word of the given name.
See screenshot for easy to understand for using syntax to move the first word to another cell.
_______________
