How to extract string after space in Excel
Extract characters before first space
To extract the string/characters before the first space in an Excal value use the following function:
=LEFT("Cell Number", (FIIND(" ", "Cell Number",1)-1))
Alternatively you can also use the following formula to achieve the same result:
=LEFT("Cell Number", LEN("Cell Number") - FIND(" ", "Cell Number"))
It is important to note in both formulas “Cell Number” is just a placeholder and should be replaced with the actual cell number for the value in which you want to extract (e.g. B2).
Extract characters after first space
To extract the string/characters after the first space in an Excel value use the following function:
=RIGHT("Cell Number", LEN("Cell Number") - FIND(" ", "Cell Number"))
Similar to extracting characters before the first space “Cell Number” here is just a placeholder and should be replaced with the actual value “Cell Number” (e.g. C3).
Lets breakdown the syntax for the formula: * =FIND(” “, “Cell Number”) will return the position of the first space in your selected string.
LEN(“Cell Number”) will return the number of characters for the whole string. So LEN(“Cell Number”) - FIND(” “, “Cell Number”) will return the number of characters after the first space.
Finally RIGHT(“Cell Number”) will return the string with the number of characters calculated based on the aformentioned formula).
Keep Learning:
SRC:
How To Extract Text Before/After Space Or Comma Only In Excel? How to get string after first space in Excel
