Learn Microsoft Excel Online FreeThis post will guide you how to get the current workbook path in Excel. How do I insert workbook path only into a cell with a formula in Excel. Get workbook path with Document Location You can get the workbook path from the document location feature, and copy the location to a cell. Do the… read more »
This post will guide you how to extract the first or last n characters from a text string in one cell in Excel. How do I get the first or last N characters from a string using an Excel formula. How to extract first two or last two characters of a cell with a formula… read more »
This post will guide you how to insert the file path and filename into a cell in Excel. Or how to add a file path only in a specified cell with a formula in Excel. Or how to add the current workbook name into a cell in Excel. How do I insert the current worksheet… read more »
This post will guide you how to extract part of text string from a cell in Excel. How do I extract a word from a text string in Excel. How to extract a substring from a text string in a Cell in Excel. How to extract a substring from the most left of a text… read more »
This post will guide you how to sum cells if cells begin with a specific text or number in another column in excel. How do I sum if cells start with specific text or number in another cells in excel. Assuming that you have a list of data A1:B4, and you want to sum all… read more »
This post will guide you how to remove salutations from names in the range of cells in excel. How do I remove the salutation from the names cells with formula in Excel. For example, if you have name salutations and you want to remove those salutations from name strings in excel, how to achieve it…. read more »
This post will guide you how to sort IP address in your worksheet. How do I sort IP address with an excel formula. How to sort IP address with Text To Columns feature in excel. Sort IP Address with Formula Assuming that you have an IP list of data in the range of cells B1:B5,… read more »
This post will guide you how to separate text and numbers from one cell in excel. How do I extract numbers from text string with formulas in Excel. Split Text and Numbers with Formula If you want to split text and numbers from one cell into two different cells, you can use a formula based… read more »
This post will teach you how to highlight rows in a table with conditional formatting in Excel. You will learn that how to change the color of the entire rows if the value of cells in a specified column meets your conditions, such as, if the value of cells is equal to or greater than… read more »
This post will guide you how to count the number of spaces before the text string in a cell in Excel. How to count the leading spaces before the text string in one cell with formula in excel. How do I create an excel formula that counts the number of spaces before the text string…. read more »
