learn microsoft excel

Trim Function in Excel

Home Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010
About Us Free Ebook Offline Training YouTube

Trim is an Excel function that helps to remove trailing, leading or other unnecessary spaces like double spaces between words from data. Why is this important? Functions like Vlookup and countif among others, for example, give erratic results if the unnecessary spaces are not removed. In the creation and use of userforms also we used the trim function to check whether one of our ('name') textboxes was blank. The training video describes the situation in detail.
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010
About Us Free Ebook Offline Training YouTube