Excel: Functions-II
TEXT FUNCTIONS 1. TRIM: Removes all spaces from a text string except for single spaces between words SYNTAX: =TRIM (text) TEXT: Required. The text from which you want spaces removed. EXAMPLE: 2. LEN: Returns the number of characters in a text string SYNTAX: =LEN (text) TEXT: Required. The text whose length you want to…
