Editing spreadsheet is fast and simple using DocHub. Skip downloading software to your computer and make adjustments with our drag and drop document editor in just a few quick steps. DocHub is more than just a PDF editor. Users praise it for its convenience and powerful features that you can use on desktop and mobile devices. You can annotate documents, create fillable forms, use eSignatures, and send records for completion to other people. All of this, put together with a competing cost, makes DocHub the perfect decision to replace card number in spreadsheet files with ease.
Make your next tasks even easier by turning your documents into reusable templates. Don't worry about the security of your data, as we securely keep them in the DocHub cloud.
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 thatamp;#39;s when I click 715 a 721 in this video we have a column numbers and thereamp;#39;s 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 itamp;#39;ll actually look at text and the result from the function will be text now weamp;#39;re ultimately interested in number so thatamp;#39;ll cause a slight problem but no problem weamp;#39;ll deal with it text hereamp;#39;s the text column now whatamp;#39;s the old text we want to get rid of double quote and then a space double quote comma and