Sanjida Ahmed

About author

Sanjida Ahmed, who graduated from Daffodil International University with a degree in Software Engineering, has worked with SOFTEKO since 2021. She has written over 100 articles on Excel & VBA and, since 2022, has worked as the Project Manager of the Excel Extension Development Project in the Software Development Department. Since starting this software development, she has established an outstanding workflow encompassing a full SDLC. She always tries to create a bridge between her skills and interests in Artificial Intelligence.


Software Developer


Project Manager in Microsoft Office Extension Development project in SOFTEKO.

Lives in

Dhaka, Bangladesh.


BSc in Software Engineering (SWE) in Daffodil International University.


Java (J2SE, J2EE), Spring, C#, .Net, (Core, MVC, Entity), C, HTML, CSS, PHP, UML, SQL, SQLite, VBA, VB.Net, MATLAB, Selenium, Git, Linux (Ubuntu, Mint), LaTeX, Microsoft Office.

Academic Projects



Robotics Project

  • Obstacle Avoiding Autonomous Car
  • Line Tracing and Locating an Object Robot


  • Software Engineering
  • Project Management
  • Team Management


  • Currently working as Project Manager in Microsoft Office Extension Development project in SOFTEKO.
  • Started technical content writing of Excel & VBA in October 2021 in SOFTEKO.

Research & Publication

Latest Posts From Sanjida Ahmed

How to Remove Characters in Excel (6 Methods)

Here's an overview of removing characters with various functions. Download the Practice Workbook Deleting Characters.xlsx 6 Methods to ...

How to Use COUNTA Function with Criteria in Excel (4 Methods)

This article will demonstrate four ways to use the COUNTA function with criteria to count a dataset, no matter whether the values are text, numbers, errors or ...

How to Use Excel VLOOKUP to Find the Closest Match

In this article, we will demonstrate five examples of how to efficiently implement Excel VLOOKUP to find the closest match in Excel. As an example of ...

How to Insert Subtotals in Excel: 7 Unique Methods

Method 1 - Insert Subtotals in Excel Automatically Select a random cell > go to the Data tab > click Sort. The Sort dialog box will pop up ...

How to Remove Text After Character in Excel: 4 Easy Ways

Using Find & Replace Feature Select your data. Press Ctrl + H to get the Find and Replace dialog. Or, go to the Home tab > Editing group > ...

How to Delete Blank Columns in Excel (4 Quick Ways)

Here we have three blank columns (columns D, E, and G) in our working range that we need to delete. Method 1 - Deleting Blank Columns in Excel After ...

How to Copy and Paste Thousands of Rows in Excel: 5 Methods

Method 1 - Copy and Paste Thousands of Rows from Address Bar Steps: Go to Address Bar and type in the range (in the sample dataset, it is B4:D1004). ...

How to Transpose Columns to Rows in Excel (8 Easy Methods)

Method 1 - Using Paste Special Feature 1.1. Transposing a Single Column to a Single Row Steps: Select cells B4:B10 >> press CTRL+C. You can ...

How to Add Rows with Formula in Excel: 5 Easy Methods

Method 1 - Apply Simple Mathematical Expressions Steps: We have the rows with values in them. Need to calculate the content of the rows in cell C11. ...

Browsing All Comments By: Sanjida Ahmed
  1. Glad that we could help you. Don’t hesitate to ask if you have any more Excel related problems. Here, our experts will be happy to assist you.

  2. Hi Jesse,

    Thanks for your comment. Have you checked the method no. 2 (VBA Macro to Export Excel Contents with Specified Range to a Pipe Delimited Text File) of this article? I think that solves your problem.

  3. Hi James, In some cases, Excel’s IsNumeric property doesn’t always produce the correct result in VBA. Could you please try If Cells(i, 1) = 103 Then instead of If IsNumeric(Cells(i, 1)) = 103 Then in your code?

  4. Hello Maurice,
    Really glad to help you out. Don’t hesitate to ask if you need any further assistance. Thanks.

Advanced Excel Exercises with Solutions PDF