Convert String to Array In cell A1 there is a string separated by ",": A,1,b,2,Dx Now, how can I convert A1 to […]

Sometimes we deal with data that is not standardized that we might give up, you should learn how to rebuild you data, […]

You can use the ampersand (&) operator in a formula to combine text from multiple cells into one cell, such as a […]

There are many ways to sum data in an Excel spreadsheet. For example, if you want to sum the values in cells […]

Sometimes you may want to count unique values exist in a range that contains duplicate values. You can count the number of […]

Sometimes you may want to find the first number in a text string, and deal with the numbers. In this Case, we […]

Sometimes you may want to get last value of a Column or a Row with Excel Formula, Here is an example for […]