Registration: Jan 5, 2023

Comments: 2

Total submitted: 27

Hadi Ul Bashar

Hadi Ul Bashar holds a BSc degree in Biomedical Engineering from Bangladesh University of Engineering and Technology. In January 2023, Bashar joined SOFTEKO as an Excel and VBA content developer. Since then, he has authored over 50 articles. He was engaged in two specialized training programs focused on VBA and Chart & Dashboard designing in Excel. Currently he is creating video content on Excel and VBA and has created over 70 videos. Reading books and traveling are his favorite pastimes.

Designation

Video Content Creator at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.sc in Biomedical Engineering (BME), BUET.

Expertise

Content Writing, VBA, C, C++, Python, Matlab, HTML, AutoCAD, CFD, Microsoft Office.

Experience

Technical Content Writing
Video Content Creating
Undergraduate Projects
- Haptic Based Dental Simulator
- CFD Analysis of Tracheobronchial Airway

Summary

Currently working as a Video Content Creator of ExcelDemy.
Started technical content writing of Excel & VBA in January 2023, moved to the Video Content Creator Team in July 2023.

Latest Posts From Hadi Ul Bashar

Using Excel Data Validation in Date Format – 4 Examples

This is an overview. This is the sample dataset. Example 1 - Creating a Dynamic Drop Down List of Dates In the ...

Hadi Ul Bashar Aug 6, 2024

READ MORE +

DMAX Method for Lactate Threshold in Excel

If you’re a fitness enthusiast or an expert, the possibility is that you may have heard about the Lactate threshold. The lactate threshold is an indicator of ...

Hadi Ul Bashar Nov 11, 2025

READ MORE +

How to Calculate Alpha in Excel: 4 Suitable Methods

Method 1 - Calculate Cronbach’s Alpha in Excel Steps: Go to Data >> Data Analysis >> Anova: Two Factor Without Replication and click on OK. ...

Hadi Ul Bashar Jun 2, 2024

READ MORE +

How to Calculate Percentile From Mean and Standard Deviation in Excel

In statistical analysis, percentiles are valuable measures that help us understand the distribution and characteristics of data. Microsoft Excel provides some ...

Hadi Ul Bashar Nov 11, 2025

READ MORE +

How to Create Cost of Delay Calculator in Excel (with Easy Steps)

Business analysts frequently have to choose which goods or projects to prioritize. There is a trade-off between projects, particularly about which project one ...

Hadi Ul Bashar Apr 29, 2024

READ MORE +

How to Hide Filter Buttons in Excel

We often use Excel to maintain databases in our day-to-day life. In some cases, we need to filter our data based on specific conditions. This can be done ...

Hadi Ul Bashar Nov 11, 2025

READ MORE +

How to Use Excel VBA VLookup Within Loop (3 Examples)

Overview of VBA VLookup So, what is VLookup? VLookup is a function in Excel that allows you to search for a value in a dataset ...

Hadi Ul Bashar Jul 1, 2024

READ MORE +

How to Create Pie Radar Chart in Excel

If you want to compare a set of data, Excel provides you with an option to compare in a smart way. Pie Radar Chart in Excel helps you to visualize your data ...

Hadi Ul Bashar Nov 11, 2025

READ MORE +

How to Ignore Blank Cells in a Named Range in Excel – 5 Methods

This will be the final output: The dataset showcases “Buying Price” and “Selling Price”. There are blank cells in "Selling Price”. To find the “Buy - ...

Hadi Ul Bashar Aug 11, 2024

READ MORE +

How to Use LARGE and SMALL Function in Excel (3 Examples)

If you want to find the 3rd most expensive smartphone from a list of smartphones, or you’re searching to solve a problem like this, you’re on the right page. ...

Hadi Ul Bashar Nov 11, 2025

READ MORE +

How to Create a Radial Bar Chart in Excel – 4 Steps

This is an overview: Step 1 - Preparing the Dataset The sample dataset showcases sales data of the “iPhone 14 Plus” in December 2022 in outlets ...

Hadi Ul Bashar Aug 13, 2024

READ MORE +

How to Prepare IF Statement Contains Multiple Words in Excel: 4 Methods

Method 1 - Use of Nested IF Function to Check Multiple Conditions Steps: Use the IF function in the column to get the desired output. Type the ...

Hadi Ul Bashar Jul 5, 2024

READ MORE +

Browsing All Comments By: Hadi Ul Bashar

Hadi Ul Bashar Jul 9, 2023 at 12:52 PM

Hello VIKASHINI,

Thank you for explaining your issue in a concise way. Yes, it is possible to extract the whole sentence. You can apply the following steps for that:

1. First of all, open your Word document.
2. Go to Developer tab and select Visual Basic.
3. Navigate to Insert tab and select Module.
4. Type the following code in the module and press the F5 key to run the macro.

Sub ExtractCommentsAndSentencesToExcel()
    Dim xApp As Excel.Application
    Set xApp = CreateObject("Excel.Application")
    xApp.Visible = True

    Dim xWB As Excel.Workbook
    Set xWB = xApp.Workbooks.Add

    Dim xWS As Excel.Worksheet
    Set xWS = xWB.Worksheets(1)
    xWS.Range("A1:B1").Value = Array("Sentence", "Comment")
    
    Dim rowNum As Integer
    rowNum = 2

    Dim doc As Document
    Set doc = ActiveDocument
    
    Dim cmnt As comment
    For Each cmnt In doc.Comments
        Dim sentenceText As String
        sentenceText = cmnt.Scope.Sentences(1).text
        
        xWS.Cells(rowNum, 1).Value = sentenceText
        xWS.Cells(rowNum, 2).Value = cmnt.Range.text
        
        rowNum = rowNum + 1
    Next cmnt
    
    xWS.Columns("A:B").AutoFit
    
    Set xWS = Nothing
    Set xWB = Nothing
    Set xApp = Nothing
End Sub

Check the following images that contain the sample output.

This is the output you will get in an Excel file.

Please let me know if you have any further issues.
Have a good day!
Regards,
Bashar
Exceldemy.

Reply
Hadi Ul Bashar May 11, 2023 at 10:36 AM

Hello DEEP!

From your comment, I think the most possible reason of the error could be inappropriate cell referencing. Please note that these formulas include both absolute and relative cell reference. You may copy paste the formulas, and then adjust the cell references according to your dataset. Hopefully that will solve your issue.

Output:

If you need further assistance regarding this, please feel free to send the Excel file in this email [email protected].

Regards
Hadi Ul Bashar