You would be able to take care of user defined characters. Options are available about alpha-numeric as well as non-alphanumeric characters. Typical such correction options available include remove/replace all spaces in selected cells, remove extra spaces at the beginning of selected cells, all spaces in selected cells, etc. The menu lists a lot of such correction options that should take care of most errors that occur when entering data in large spreadsheets. The additional menu item introduced with this plug-in include many replacement options, remove options and remove/replace options that can take care of the problems that exist in the target cells. This tool offers a whole range of menu choices to get the changes done automatically. Even by going to each cell, getting the changes actually done takes quite a bit of effort. Similar things can happen when editing, modifying data into the spreadsheets. These will be typically, text characters, spaces or some other characters such as blanks or some keys you may have touched simultaneously when typing in. When typing in a lot of data into spreadsheets, extraneous characters can get typed in.
#Uninstall sobolsoft software
This software is a plug-in to the MS Excel spreadsheet program. Tick off the Back up the worksheet option to keep the original data intact.Ĭlick the Remove button to see the results.This tool will help users remove text, spaces and other characters from data entered into Excel sheets.To perform case-sensitive search, check the Case-sensitive box.If you do not check it, the values will remain in the cells. If you check off the Including delimiters option, the substring will be removed together with the values you entered. For this, enter both values into the corresponding boxes. You can also Remove all substrings between value 1 and value 2.All characters after text will remove everything after the specified character or string in the selected cells.All characters before text will delete any values before the specified character or string in the range you select.Select The last N characters to remove any number of characters at the end of each cell in your range.Pick The first N characters to delete any number of characters at the beginning of the needed cells in Excel.Click Expand selection to get the entire table highlighted automatically.The range address can be seen at the top of the pane. To remove characters by position, select the range in Excel that contains the values you want to delete.You can see the add-in's pane with the following options: Run the Remove by Position tool by clicking the Remove icon on the Ablebits Data tab in the Text group: Delete any combination of characters, e.g. Symbols and punctuation marks - remove all punctuation marks from the cells as well as the following symbols: mathematical, geometric, technical and currency symbols, letter-like symbols such as ?, 1, and ™.Numeric characters - delete all digits from the range of interest.Text characters - remove all letters from your cells.
#Uninstall sobolsoft code
Non-printing characters - delete all non-printing characters like line breaks, the first 32 non-printing characters in the 7-bit ASCII code (values 0 through 31), and additional nonprinting characters (values 127, 129, 141, 143, 144, and 157).There are several sets of symbols you can pick from the drop-down list: If you have several symbols that you need to cut out from your range and you don't want to repeat this routine operation, just enter each character to eliminate into the Remove custom characters field and the add-in will delete all its instances in the selected cells.
Remove custom characters will delete the characters you enter into this field.Choose the option that meets your needs:.Click the Expand selection icon to highlight the entire table automatically.You will see the range address right in this field. Select the cells that contain the values you want to delete.Pick the Remove Characters option from the drop-down list and see the add-in's pane: Run the Remove Characters tool by clicking the Remove icon on the Ablebits Data tab in the Text group: