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.
I put text into A1 and A2 and in B1 I want to put them together and add a break in between them. The formula I use is: =A1&CHAR(10)&A2. Notice this time that Excel does not automatically turn on Wrap Text when we enter the line break as a formula.