Prantick Bala

About author

PRANTICK BALA is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he has transitioned into the role of a content developer. Beyond his work, find him immersed in books, exploring new places during travels, and enjoying movies and TV series in his downtime.

Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

Expertise

Rhino3D, Maxsurf, C++, MS Office, AutoCAD, WordPress and Excel & VBA

Experience

  • Intern at Khulna Shipyard, Khulna, Bangladesh.
  • Probationary Officer at United Commercial Bank PLC, Bangladesh.

Latest Posts From Prantick Bala

0
How to Remove Formatting in Excel Without Removing Contents

"Removing formatting in Excel without removing contents" means separating the raw data (text, numbers, formulas) from formatting (font styles, colors) in a ...

1
How to Remove Single Quotes in Excel (6 Ways)

Sometimes we have data with single quotes in our Excel datasheet. If the data have single quotes Excel automatically hides the leading apostrophe of the ...

1
How to Clear Contents in Excel Without Deleting Formulas

Oftentimes, we may want to remove values from our Excel spreadsheet. Now, what if we need to erase only the contents without affecting the formulas? Sounds ...

1
How to Add Leading Apostrophe In Excel (4 Ways)

Excel may treat certain entries, particularly numbers that start with zeros, as formulas or numeric data. By adding a leading apostrophe to a cell entry, Excel ...

2
Conditional Formatting Entire Column Based on Another Column in Excel

In Excel, conditional formatting is used to highlight any cells based on predetermined criteria and the value of those cells. We can also apply conditional ...

1
How to Highlight Cells in Excel Based on Value (9 Methods)

In Excel, you can use various methods to highlight cells based on their value. In this article, I’ll show you 9 methods by which you can highlight cells based ...

1
How to Apply Conditional Formatting to Multiple Rows (5 Ways)

Without a doubt, Conditional Formatting is a nifty feature of Excel that allows us to highlight cells based on any criteria. So, we can, at a glance, locate ...

1
How to Sum Values by Day in Excel (8 Easy Ways)

You can make summations in Excel based on a specific date or day. In this article, we’ll show you 8 easy ways to sum values by day in Excel. 8 Easy ...

1
How to Remove Decimals in Excel (13 Easy Ways)

If the numbers of your dataset have decimals, you may want to remove them to make the dataset look simple. Removing decimals is quite easy; you can do it in ...

1
How to Remove Blank Spaces in Excel (7 Ways)

If your data set contains blank spaces which are unnecessary you may need to remove them. In this article, I’ll show you seven effective ways to remove blank ...

2
How to Trim Right Characters and Spaces in Excel (5 Ways)

Sometimes our data cells may have some additional characters attached to the right which is not required. You can trim these characters from the right of your ...

0
How to Remove Leading Space in Excel (5 Useful Ways)

Sometimes there may be some extra spaces at the front of your data in Excel and you may need to remove these extra leading spaces to use this data. In this ...

1
How to SUMIF for Multiple Criteria Across Different Sheet in Excel

Excel is the most widely used tool for dealing with massive datasets. If you have data across different sheets and want to sum those data based on multiple ...

1
How to Insert a Total Row in Excel (4 Easy Methods)

Total row in Excel helps us get a quick summary of different columns from a table or a range of cells. In this article, I’ll show you 4 easy and quick methods ...

1
Split String by Character in Excel (6 Suitable Ways)

Sometimes you may have a dataset where different kinds of data are inserted in a cell and separated by a character such as a delimiter, a hyphen, a dash, etc. ...

Browsing All Comments By: Prantick Bala
  1. You are welcome, Adam. Feeling happy to know that this article has solved your problem.

  2. Thanks dar for finding the article helpful.
    Would you please share your Excel sheet?
    Then I’ll be able to understand what you are actually want to do and try my best to give you a solution.

  3. Hello Paul,
    I hope you have found your solution already. If not, please share your Excel workbook with me. It is difficult to say the reason for the error message without seeing your worksheet or code. I will try my best to solve your problem.

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo