Need to rapidly delete number in quote? Your search is over - DocHub has the answer! You can get the job completed fast without downloading and installing any software. Whether you use it on your mobile phone or desktop browser, DocHub enables you to edit quote anytime, anywhere. Our versatile solution comes with basic and advanced editing, annotating, and security features, suitable for individuals and small companies. We also provide lots of tutorials and instructions to make your first experience effective. Here's an example of one!
You don't need to bother about data security when it comes to quote modifying. We provide such protection options to keep your sensitive data safe and secure as folder encryption, two-factor authentication, and Audit Trail, the latter of which tracks all your activities in your document.
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 lets try the substitute method and to say look at that text there whats 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 its staying invalid and it wont 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 youll see it removes the quote marks so weve done that and again its not quite as a number yet so we then use our value function just to force it to become a number
