Whether you work with papers every day or only occasionally need them, DocHub is here to assist you make the most of your document-based projects. This platform can copy space in Indenture, facilitate user collaboration and create fillable forms and valid eSignatures. And even better, everything is kept safe with the top security standards.
With DocHub, you can get these features from any location and using any platform.
welcome to xox trick number 715 hey if you want to download this workbook and follow along click on my youtube channel and click on my college website link and you can download the workbook thats when I click 715 a 721 in this video we have a column numbers and theres spaces between them and our goal is to get rid of the spaces and have the complete number without spaces so we can do a formula over here and all we need our formula to do is look find all the spaces and substitute in the place of a space put nothing will use the substitute function substitute it wants text now substitute is like mid and right and left itll actually look at text and the result from the function will be text now were ultimately interested in number so thatll cause a slight problem but no problem well deal with it text heres the text column now whats the old text we want to get rid of double quote and then a space double quote comma and new text well we want nothing on the syntax for nothing is doub