Learn Microsoft Excel Online FreeThis post will guide you how to combine multiple cells in a row or column into one cell with a specified character, such as: comma, hash, space, semicolon and so on. How to achieve it? And this post will let you learn two ways to combine or merge range of cells in a row or… read more »
This post will guide you how to count and sum cell by background color in excel. How to get the sum of colored cells in the current worksheet. How do I count cells by background color of cells with user defined function in excel VBA. How to Sum cells by background color in excel. Count… 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 explains that how to count the number of words in a cell using excel formula. How to count total words in a cell with User Defined Functions in excel VBA. Count the number of words in a cell If you want to count the number of words in a single cell, you can… read more »
This post will guide you how to convert a column letter to a column number using an excel formula. And how to write a user defined function to convert column letter to number in excel VBA. Convert column letter to number using excel Formula If you want to convert a column letter to number, you… read more »
This post explains that how to convert a column number to a column letter using formula in excel. How to convert column number to a column letter using user defined function in VBA. Convert column number to letter using excel formula if you want to convert column number to letter, you can use the ADDRESS… read more »
In the previous post ,we talked that how to get the position of the last occurrence of a character in a cell, and sometimes, you may be want to know the position of the 2th, 3th or nth occurrence of a character in a text string in excel. and this post will guide you how… read more »
This post explains that how to convert the text to an Array in excel. How to convert text into array using formula in excel 2013? How to split the text string into an array where the each character in text is an element in array using excel formula in excel 2013. How to split text… read more »
This post explains that how to remove numeric characters (numbers) from a text string in one cell in excel 2016. how to remove only numeric characters but keep the non-numeric characters from a cell containing text string with an excel formula. And how to remove numbers from a cell with a user defined function in… read more »
