Change Text to Title Case or Capital Case in Excel
Sometimes you may get text data in Excel that is all in uppercase, lowercase, or mixed case as in the example data below:…
Tag: SEO
Create or Remove Hyperlinks in Excel
If you want quick access to associated information on a web page or another file, you can create a hyperlink in a worksheet…
Extract Domain from URL in Excel
You can use Excel to process huge lists of URLs and generate useful reports such as a report on new links to a…
Trim and Combine Spaces in Excel
If you import data from legacy systems and external databases into Excel, you most likely will find that the data contains extra spaces….
Remove Excess Tab Symbols from an Excel Spreadsheet
It is easy to import data into Excel from other sources such as MS Access, Oracle, or MySQL databases. However, many times the…
Format Numbers in Thousands and Millions in Excel
When you are dealing with large numbers where precision is less important than readability, there are a few methods you can use to…
Shortcut Key for Uppercase in Excel
Contrary to Word, Excel offers less advanced features when it comes to text modification. For example, there is no Change Case button. We…