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.
"Removing formatting in Excel without removing contents" means separating the raw data (text, numbers, formulas) from formatting (font styles, colors) in a ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS
You are welcome, Adam. Feeling happy to know that this article has solved your problem.
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.
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.