Here is Schlage Locks phone number for customer service at 888-805-9837 helpline to contact Locks for technical support online help to fix your problem and get
Thanks to TRIM function you can remove spaces from the text. Syntax of TRIM function is: =TRIM(text). If you have text with extra spaces in A1 cell, just writhe a formula =TRIM(A1). TRIM function remove extra spaces which you doesn't need.
Assuming the text is in A1, the number of digits in it are, =SUMPRODUCT(- -ISNUMBER(MID(A1,ROW($A$1:$A$200),1)+0)). MID(A1,ROW($A$1:$A$200),1) + 0 portion: This breaks the text in A1 in to individual characters (assumes the max length is 200) and then adds 0 to them.