Are you looking for a fast and simple way to remove text in Service Quote? Your search is over - DocHub gets the job done fast, without any complicated software. You can use it on your mobile phone and desktop, or browser to edit Service Quote anytime and anywhere. Our comprehensive toolset contains everything from basic and advanced editing to annotating and includes security measures for individuals and small companies. We provide tutorials and instructions that assist you in getting your business up and running right away. Working with DocHub is as simple as this.
Easy, right? Even better, you don't need to be concerned about information protection. DocHub delivers quite a number of features that help you keep your sensitive data risk-free – encrypted folders, dual-factor authorization, and more. Take advantage of the bliss of reaching your document management goals with our professional and industry-compliant platform, and kiss inefficiency goodbye. Give DocHub a try today!
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