Showing posts with label Trim Function. Show all posts
Showing posts with label Trim Function. Show all posts
Thursday, 11 February 2010
SPREADSHEET TIPS & TRICKS: The “Trim” Function
Ever had a data series that needed cleaning? This function removes spaces from the front and back of a set of characters in an Excel cell. For example, you may need to perform the Vlookup function on a list of client codes in an Excel spreadsheet.
Subscribe to:
Posts (Atom)
Posts
