TRIM(text) removes spaces from text : TRIM « Text functions « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Text functions
3. TRIM

Input the formula: =TRIM(" First Quarter Earnings ")

22.23.TRIM
	22.23.1.	TRIM(text) removes spaces from text