Things to Remember:
– Number formatting will be ignored i.e. $10,000.00 output result will be 5 (for 10000) ignoring “$”/”,”/”.00” number formatting
– Space available in a string is counted as character
– Function should give output in “General” format, however if output is not as per the desired format then we need to change the cell format to “GENERAL”.
Very well explained LEN function.