Are you searching for a quick and easy method to remove text in Price Quote? Your search is over - DocHub gets the job done fast, without any complex application. You can use it on your mobile phone and desktop, or web browser to modify Price Quote at any time and anywhere. Our versatile toolset contains everything from basic and advanced editing to annotating and includes security features for individuals and small businesses. We provide tutorials and instructions that aid you in getting your business up and running without delay. Working with DocHub is as simple as this.
Simple, right? Even better, you don't need to be concerned about data safety. DocHub offers quite a number of tools that help you keep your sensitive data safe – encrypted folders, dual-factor authorization, and more. Enjoy the bliss of getting to your document management objectives with our reliable and industry-compliant platform, and kiss inefficiency goodbye. Give DocHub a try right now!
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
