Tip Printed from ExcelTip.com
Extract the first word in a cell in Microsoft Excel



Enter the following text in cell A1:	 	Are you going to Disneyland? 

Use the following function:
	
		=IF(ISERR(FIND(" ",A1)),A1,LEFT(A1,FIND(" ",A1)-1)) 


The result:				Are