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.
Here's an overview of removing characters with various functions. Download the Practice Workbook Deleting Characters.xlsx 6 Methods to ...
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 ...
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 ...
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 ...
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 > ...
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 ...
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). ...
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 ...
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. ...
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.
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.
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?
Hello Maurice,
Really glad to help you out. Don’t hesitate to ask if you need any further assistance. Thanks.