lazoom.blogg.se

Now you can delete values only of the same text case with the Remove Characters option. IMPROVED: Case sensitivity in Remove Characters Now you can make the Count Characters tool count certain characters in the selected text case only. IMPROVED: Case sensitivity in Count Characters For this, make sure that files are synced and opened from your local device. Now you can compare sheets from OneDrive with the Compare Two Sheets tool. See also: How to use Remove Duplicate Substrings IMPROVED: Compare sheets from OneDrive You just choose the delimiter used, decide whether the text case of the substrings is important or not, and then you get clear unique data in each cell. Remove Duplicate Substrings can find and remove duplicates within a cell. See also: How to use Text to Date NEW: Remove Duplicate Substrings You can choose the date order, keep or exclude time, and mark not converted cells with color so that you can easily find them. Text to Date will help you to convert dates formatted as text to true Excel dates. See also: How to use Spell Number NEW: Text to Date

Besides, you are free to choose a currency (if needed), letter case, the way decimals are displayed, and get the result pasted as a formula. Now you can get any numbers written out in words. One more new tool of the Utilities group is Spell Number. See also: How to use Add/remove leading zeros NEW: Spell Number You will find the tool in the Utilities group. It can remove zeros when there is no more need in them, too. See also: How to use Find Duplicate Cells NEW: Add or remove leading zerosĪdd/remove leading zeros adds the required number of visible leading zeros to your data just in one click.

There are various ways to process the found items:Ĭlear all (contents, formatting and comments) You can specify what cell similarities are important for you: values, formulas, background, font color, or any combination of these options. With Find Duplicate Cells, you can look for duplicate or unique cells with or without 1st occurrences in the range you select. Besides, you'll get five new highly useful tools to complete your Excel tasks even faster 😉 NEW: Find Duplicate Cells In the 2021.2 release, we made several fixes and added some improvements to the existing features.