Learn Microsoft Excel Online Free
In daily life, we can use repeated characters to indicate the magnitude or priority of something. For example, a single “!” indicates a minor case, double “!!” indicates a medium case, and triple “!!!” indicates a high case, and so on. In an Excel worksheet, we can use REPT function to output a different number… read more »
Suppose that you have listed some text in a single cell which is separated by the line break(you can do it by pressing ALT + ENTER after entering the text), and now you want to extract multiple lines of text from a single cell into a separate cell, just like it has been done in… read more »
This post will guide you how to count the number of cells that contain exactly N charcters within a range of cells using a formula in Excel 2013/2016.You can easily to count cells equal to a specific value or text string through COUNTIF function. But if there is an easy way to count cells that… read more »
This post will guide you how to extract email address from a text string in Excel. How do I use a formula to extract email address in Excel. How to extract email address from text string with VBA Macro in Excel. Assuming that you have a list of data in range B1:B5 which contain text… read more »
This post will guide youw how to reverse the concatenate function in Excel. how do I split the text string into the muliptle cells with a formula in Excel. How to split text data of a cell to multiple cells in Excel. Reverse Concatenate Formula To reverse concatenate formula in Excel, you can use a… read more »
This post will guide you how to extract the nth word from a text string in excel. How do I get the nth word from text string in a cell using excel formula. How to write a User Defined Function to extract nth word from text. Extract nth word If you want to extract the… read more »
This post will guide you how to extract word that containing a specific character using formula in excel. How to get a word that contains a specific character (such as: @, comma, hash, etc.) in a text string in one cell. Extract word that containing a specific character If you want to extract word that… read more »
This post will guide you how to extract a word that starts with a specific character in excel. Extract word that starting with a specific character For example, Assuming that you have a text string that contains email address in Cell B1, and if you want to extract word that begins with a specific character… read more »
This post will guide you how to extract text between commas in excel. Before we talked that how to extract text between brackets using a formula with MID and SEARCH functions. And this post will extract text between commas instead of brackets. The biggest difference is that the brackets have the left and right, but… read more »
This post will guide you how to split multiple lines from a cell into separated rows or columns in Excel. You will learn that how to extract text string separated by line break character into rows in excel 2013. In the previous post, we talked that how to split text string by only one line… read more »
This post will guide you how to use Excel REPT function with syntax and examples in Microsoft excel. Description The Excel REPT function repeats a text string a specified number of times. The REPT function is a build-in function in Microsoft Excel and it is categorized as a Text Function. The REPT function is available in Excel… read more »
