Latest Posts From Mahbubur Rahman
While working with Excel, you may feel the need to find particular text within a selected cell, or even feel the need to replace that text. Microsoft Excel ...
Mahbubur Rahman
We all know about transposing in Excel. What about reverse transpose? It is slightly a different concept. In this web post, we will see How to Reverse ...
Microsoft Excel has features to automatically convert Excel files to CSV files or text files. Moreover, we can convert Excel files to a pipe-delimited text ...
There are numerous ways to split text in Excel. In this article, we will see several methods for Excel split text by space formula. We have a sample dataset ...
Suppose we have a list of Name, Profession, Age, and Region. From the list, we want to get random Names but based on specific criteria. How should we do that? ...
In most office applications adding a new line, paragraph or space down is not a problem. But Microsoft Excel is different in this case. We will see how to ...
We occasionally need to print exported files or files that we have received from others. In that case, we may face difficulties with print titles that come as ...
The FILTER function allows us to filter a set of data based on a set of criteria. Filtering data based on a list in another worksheet is also beneficial. When ...
In Excel, interpolation allows us to get the value between two points on a graph or curve line. It is used to detect or anticipate the future value that lies ...
While dealing with a huge amount of data, we often encounter duplicate entry problems in Excel. The most used methods to find duplicates in Excel are the ...
In Microsoft Excel, hyperlinks are used as a link to certain web pages. It can also be a handy tool to link another file, Excel sheet, or cell. By clicking ...
While working with Excel, sometimes we notice that our data contains values in Currency Format. Excel automatically includes a Dollar symbol for the cells ...
While Microsoft Excel is usually used for calculations, you may wish to save images with data in some cases and correlate an image with a specific piece of ...
To explain detecting and adding text to cells, let's use a sample dataset containing ID, Product Name, and Size. Method 1 - If Cell ...
The wildcard is a special character that helps us to match texts in Excel. This is a very handy tool. Excel has three characters as wildcards to use in ...
