When your everyday tasks scope includes a lot of document editing, you realize that every document format needs its own approach and sometimes specific software. Handling a seemingly simple excel file can often grind the entire process to a stop, especially when you are attempting to edit with inadequate tools. To prevent this sort of problems, get an editor that can cover your requirements regardless of the file format and cut character in excel with zero roadblocks.
With DocHub, you will work with an editing multitool for virtually any occasion or document type. Minimize the time you used to devote to navigating your old software’s functionality and learn from our intuitive interface design while you do the work. DocHub is a streamlined online editing platform that covers all of your document processing requirements for virtually any file, including excel. Open it and go straight to efficiency; no prior training or reading guides is needed to reap the benefits DocHub brings to papers management processing. Start by taking a few minutes to register your account now.
See upgrades within your papers processing just after you open your DocHub account. Save time on editing with our one platform that will help you be more productive with any file format with which you need to work.
[Music] in this video we are going to see how to remove special characters in excel we use the text dot select function it is a power query m function that helps to easily work with data models using formulas and expressions here is a column of values each cell in this column contains a text string made up of letters numbers and special characters what were going to do now is remove the numbers and special characters and keep only letters first select one of the cells in the column containing the special characters then select the data tab on excels ribbon click the from table button the create table dialog opens the data range should already be defined if not select the cells you want to remove special characters from if you already have a column heading make sure the my table head headers check box is checked click on ok to confirm power query is launched in a separate window displaying your data select the add column tab on power queries ribbon then click the custom column button