File renaming applications are great if you need to rename a lot of files. They can be even better if you can use Excel’s built-in functions such as TRIM, SUBSTITUTE, FIND, LEFT, and RIGHT in order to clean up and generate your new file names. Excel VBA File Renamer for Windows is my take on the idea and can be downloaded here: dailyexcel.net Excel VBA File Renamer for Windows dailyexcel.net Excel VBA File Renamer for Windows enables you to …
Tag: LEFT function
SUMIFS by text string length
Values that meet one or more criteria can be added up with the SUMIFS function. The sum of values next to cells containing specific text, i.e., a sum based on text criteria, is possibly the most common use case. The sum of values next to cells containing (non) specific text of a defined length (the defined number of characters in a text string) is a far less common need, but still crucial in specific situations. We can accomplish this …
How to MATCH numbers formatted as text in Excel
You will sometimes encounter issues while trying to MATCH or LOOKUP data in Excel if your numbers are formatted as numbers in one of your tables and as text in another table. While special formats are available in Excel, they are relatively rarely used and are limited. Some “numbers”, such as identification numbers, are more often stored as text. This is done in order to add leading zeros, hyphens, and other characters to those numbers. However, if we try to …
Text in Excel
Text-related features Excel may have a reputation for crunching numbers, but text-formatted data such as names, addresses, and descriptions is often encountered. Excel is also often used for processing data from a wide variety of unrelated databases, applications, and web sites. With those, issues such as numbers formatted as text, text formatted as numbers, multiple text fields combined into a single cell, and broken tables are not uncommon. Further complicating things, Excel functions designed to manipulate text-formatted data are many, …