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.