# Sanjida Ahmed

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.

## Designation

Software Developer

## Position

Project Manager in Microsoft Office Extension Development project in SOFTEKO.

## Education

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

## Expertise

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

### Robotics Project

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

## Experience

• Software Engineering
• Project Management
• Team Management

## Summary

• 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.

## How to Check If a String Contains Another String in Excel Using VBA (6 Methods)

Method 1 - Checking for Substrings Open the Visual Basic Editor by pressing Alt + F11 or navigating to the Developer tab and clicking on Visual Basic. ...

## How to Find a String with VBA in Excel (8 Examples)

Introduction to InStr Function in Excel VBA The InStr function in Excel VBA allows you to find the position of specific strings within a given text. ...

## How to Use The SUMIFS Function to SUM Values in a Date Range in Excel -11 Examples

The Excel SUMIFS Function The SUMIFS function is used to find the sum of a range of values with given conditions. Generic Syntax: =SUMIFS(range1, ...

## How to Convert Bulk Text to Number in Excel (6 Suitable Ways)

In this article, we will show you how to convert bulk text to numbers in Excel in 6 ways. Consider the following dataset of Product and Order IDs. ...

## Excel VBA to Transpose Array (3 Suitable Examples)

The generic syntax of transposing an Array with VBA is: WorksheetFunction.Transpose(Arg1) Arg1 = It is a required argument which is a range of cells ...

## How to Extract Data Based on Criteria from Excel: 6 Ways

Let's use a List of Students with Their Obtained Marks. This dataset contains the ID, Name, and their corresponding Marks and Departments in columns B, C, D, ...

## Using a VBA Macro to Insert Rows in Excel Based on Criteria – 4 Methods

Method 1 - Using a VBA Macro to Insert Rows Based on the Cell Text Value in Excel To insert a new row based on the specific text value “Insert Above” in the ...

## How to Use VBA to Remove Numbers from a String in Excel – 4 Methods

This is an overview. Below is the sample dataset. Method 1 - Delete Leading Numbers from String with Excel VBA Steps: Press Alt + ...

## How to Count Colored Cells in Excel (4 Simple Ways)

In this dataset, there are three categories: Fruit, Flower, and Food, each marked with a different color. Let's count the cells with a specific color, as shown ...

## How to use the SUM with IFERROR in Excel – 4 Methods

If there is a cell with #N/A, #VALUE, or #REF! value in the selected range in which you want to apply the SUM function, it will return #N/A. Method 1 - ...

## How to Use INDEX-MATCH Function for Multiple Results in Excel

In this article, we will show you how to use the INDEX-MATCH formula in Excel to generate multiple results. We'll use the following dataset containing ...

## How to Use VLOOKUP with SUM Function in Excel (6 Methods)

This article will show you how to use the VLOOKUP function with the SUM function to execute certain operations in Excel. Before diving into the methods, have a ...

## How to Remove Characters from String Using VBA in Excel?

The sample dataset is the Premier League Point Table of the 2012/13 Season. In the dataset, we have Manchester United as the Champion Team. But in cell B17, we ...

## How to Make VLOOKUP Case Sensitive in Excel?

Consider the following dataset of students. In that dataset, there are two students who have the same first names but different surnames and obtained different ...

## How to Delete Row If Cell Contains Value Using Macro in Excel (2 Examples)

In this article, we will use a VBA macro to delete cells that contain either a string or numbers, as in the following gif. The VBA syntax to delete ...

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,