Md. Mehedi Hasan, with a BSc in Electrical & Electronic Engineering from Bangladesh University of Engineering and Technology, holds a crucial position as an Excel & VBA Content Developer at ExcelDemy. Driven by a deep passion for research and innovation, he actively immerses himself in Excel. In his role, Mehedi not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently deliver exceptional and quality content. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, Verilog, Assembly, Arduino, MATLAB, Pspice, and HFSS.
When we create an Excel worksheet, the document automatically includes some properties. The properties are important to identify the document. In this article, ...
When we have a vast dataset in Excel, it’s a bit hard to look at and find specific data from the dataset. But Excel is awesome, it has many built-in functions ...
Calculating percentages is a very useful mathematical operation while working on an Excel worksheet. We can use the COUNTIF function of Excel for the ...
Both Excel and Google Sheets are widely used for data analysis and performing different sorts of calculations and both have some specific benefits. Sometimes, ...
Highlighting cells is quite useful while working on the Excel worksheet. The highlighted cells can be spread out through the sheet and we may want to copy the ...
While working on Excel sometimes we want to attach files to the worksheet. For example, we may wish to include a zip file in the worksheet. This comes in handy ...
A Comma-Separated Values(CSV) file is a delimited text file with commas. It comes in handy during different sorts of data analysis. Sometimes you may be ...
Changing the column width in Excel is a must while working as the length of our input may be larger than the column width. In that case, the cell doesn’t ...
The SUMIFS function of Excel is widely used when we want to sum data if criteria are matched. We may want to sum the data from multiple sheets also. In this ...
While working on Excel most of the time we create multiple sheets and it becomes necessary to rename the sheets. It's quite hazardous to rename each sheet ...
Sometimes we need to calculate the hour between 2 times from different or the same date. It's quite simple to do in Excel. We can find the hour difference in ...
Excel is widely used to make financial statements of any company or business whether it is a big one or a small one. We can use different Excel functions and ...
Leave Salary means the salary an employee gets even at the time of leave. Leave Salary Calculation is quite vital for any business or company and it varies ...
The theoretical data and experimental data don't always match. In that case, we can calculate the error percentage by subtracting theoretical data from ...
CD Interest Calculator helps to calculate the total amount including compounded interest that we will receive when we invest the amount in the Certificate of ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS
Thank you for your queries. Let’s change the code a bit. Use the following code to copy the data and paste it as values.
Afterward, you will see result like this.
Thank you so much for your observation. We will rectify and update this error soon. Thanks again for your concern.
Hi MIGUEL,
We are glad, you asked the questions. It’s quite easy to import data from separate sheets and save it as separate documents. Simply, use the following code in a new module of VBA. Only, you have to change the file directory to save the doc file.
After running the code, you will see the doc files created according to your dataset.
Hi Anna!
You wanted to say what will happen if we input the same word with Upper and Lower case. The fact is Excel counts Upper and Lower case characters as the same. So you won’t have any issues. Even then I am showing one way to make your data to proper format first. Then, use the formatted text in the required formula.
=PROPER(B5)