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)

While working with a large dataset, removing characters manually when needed is not a wise way. In this article, we will show you how to remove characters in ...

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

While working with a large dataset, sometimes we need to know the total number count of some certain dataset no matter whether it is a text or numbers or error ...

How to Use Excel VLOOKUP to Find the Closest Match

Sometimes, we want to find a unique value in a large set of data, or an approximate value of a certain data. But when the data are huge, it is not a wise way ...

How to Insert Subtotals in Excel (7 Unique Methods)

When dealing with extensive datasets, it becomes crucial to summarize and organize information effectively. This is where the power of subtotals comes into ...

How to Remove Text After Character in Excel (4 Easy Ways)

TL;DR: To remove text after a character in Excel, follow the steps: Select your data. Press Ctrl+H. The Find and Replace dialog box will appear. ...

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

In this article, we will learn about how you can delete blank columns in Excel. Blank columns can create problems while formula calculation or exporting data. ...

How to Copy and Paste Thousands of Rows in Excel

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make databases for ...

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

Everyone has their own point of view when visualizing and representing data. Some may feel comfortable working with data when they are in the horizontal ...

How to Add Rows with Formula in Excel (5 Easy Methods)

While working with a large dataset in Excel, you want to know the total value of a particular row or multiple rows. In Excel, you can do that in many ways. ...

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