Posts Tagged 'Excel formulas', page 8
How to quickly extract domain names from URLs in Excel
A few tips and pieces of advice will help you get domain names from a list of URLs using Excel formulas. Two variations of the formula let you extract the domain names with and without www. regardless of the URL protocol (http, https, ftp etc. are supported). The solution works in all modern versions of Excel, from 2007 through 2016. Continue reading
How to change the row color based on a cell's value in Excel
Learn how to quickly change the color of the entire row based on a single cell's value in your Excel worksheets. Tips and formula examples for number and text values. Continue reading
How to enter the same data (formula) into all selected cells at a time
In this quick tip you will learn about 2 fast ways to enter the same formula or text into several Excel cells at a time. It is very useful if you need to insert the formula to all cells in a column or fill all blank cells in a table with the same value (e.g. "N/A"). Both tricks work in Microsoft Excel 2013, 2010, 2007 and lower. Continue reading
