Editing spreadsheet is fast and simple using DocHub. Skip installing software to your computer and make alterations using our drag and drop document editor in just a few fast steps. DocHub is more than just a PDF editor. Users praise it for its convenience and robust features that you can use on desktop and mobile devices. You can annotate documents, make fillable forms, use eSignatures, and deliver records for completion to other people. All of this, put together with a competing price, makes DocHub the perfect option to undo letter in spreadsheet files effortlessly.
Make your next tasks even easier by turning your documents into reusable templates. Don't worry about the safety of your information, as we securely keep them in the DocHub cloud.
in this video iamp;#39;m going to demonstrate how we can remove numbers from text in google sheets or the other way around if you want to remove text but keep numbers so for that iamp;#39;m going to go next to this and create a formula iamp;#39;m gonna do regex replace and this is a function thatamp;#39;s gonna replace using a regular expression pattern so what we do we point to our initial text comma and then the next part is going to be regular expression in quotes so iamp;#39;m going to go ahead and type quotations and in regular expressions the way we point to a number that would be this slash d that means number in regular expression after that iamp;#39;m going to do a comma and say what i want to replace it by and i donamp;#39;t want to replace it by anything so iamp;#39;m just going to close parentheses and hit enter and if you drag it down that should take care of it so now numbers are gone we only have the remaining characters left now letam