Extract Text Before/After Space Or Comma Only In Excel | Specific Text in exel

Extract Text Before Space With Formula In Excel

You can quickly extract the text before space from the list only by using formula.

Select a blank cell, and type this formula 

=LEFT(A1,(FIND(" ",A1,1)-1))

 (A1 is the first cell of the list you want to extract text) , and press Enter button.

Extract Text After Space With Formula In Excel

use this formula =MID(A1,FIND(" ",A1)+1,256).