When you edit documents in various formats every day, the universality of your document solution matters a lot. If your instruments work with only a few of the popular formats, you might find yourself switching between software windows to delete symbol in xls and handle other file formats. If you wish to remove the headache of document editing, get a solution that will easily handle any format.
With DocHub, you do not need to focus on anything short of the actual document editing. You won’t need to juggle programs to work with various formats. It will help you revise your xls as easily as any other format. Create xls documents, edit, and share them in one online editing solution that saves you time and boosts your efficiency. All you need to do is register a free account at DocHub, which takes only a few minutes or so.
You won’t have to become an editing multitasker with DocHub. Its feature set is enough for fast papers editing, regardless of the format you want to revise. Begin with creating a free account and see how effortless document management might be having a tool designed specifically for your needs.
[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