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.
Hereâs a full breakdown of how it works: 1  Select the cell or column that contains the text you want to split. Note: Select as many rows as you want, but no more than one column. 2  Click Data >Text to Columns. 3  This starts the Convert Text to Columns Wizard. Click Delimited > Next. Check Space, and clear the rest of the boxes, or check Comma and Space if that is how your text is split (Smith, John, with a comma and space between the names). You can see a preview of your data in the Data preview window.