Things to Remember:
– Spaces available in a string is counted as characters
– Currency symbols (Number Formatting) are not counted as characters and will be ignored by the function
– If “num_chars argument” field is blank, it will be counted as 1 (by default) and 1st character of the string will return as output
– “num_chars argument” should not be a negative value otherwise function output will return to “#VALUE!” (Error)
– If value in “num_chars argument” is greater than the total count of characters in a string, then function’s output will return the complete string.