Excell Calculations for Text after and Before Space

Add to favorites

Excel give characters after space

If you want to extract the text after space only, use this formula 
=MID(A1,FIND(" ",A1)+1,256)

Excel give characters before space

Extract text before or after space with formula in ExcelYou 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.