With DocHub, you can quickly erase quote in OSHEET from any place. Enjoy features like drag and drop fields, editable text, images, and comments. You can collect eSignatures securely, add an additional level of defense with an Encrypted Folder, and work together with teammates in real-time through your DocHub account. Make adjustments to your OSHEET files online without downloading, scanning, printing or mailing anything.
You can find your edited record in the Documents folder of your account. Prepare, share, print out, or turn your file into a reusable template. With so many robust tools, it’s simple to enjoy effortless document editing and managing with DocHub.
he has a real data extract where everything has come with quotes around it including the number what we want to do is just turn it into a number and typically we could use one of two methods so letamp;#39;s try the substitute method and to say look at that text there whatamp;#39;s the old text so my logic would be in inverted comma inverted comma inverted comma so two inverted commas with one in the middle to tell it to get rid of that one get rid of that one replace it with nothing but as you can see itamp;#39;s staying invalid and it wonamp;#39;t allow us to do it so this is a unique situation in Excel where what you need to do going to pointed the text the old text now is actually Four quote marks in a row new text is nothing so just two quote marks next to each other when I say okay youamp;#39;ll see it removes the quote marks so weamp;#39;ve done that and again itamp;#39;s not quite as a number yet so we then use our value function just to force it to become a number
