Puneet Gogia

Macro codes can save you a ton of time. You can automate small as well as heavy tasks with VBA codes. And do you know? With the help of macros,

Experts know the importance of serial numbers. Serial numbers are like salt. You never feel their presence but their absence makes your data tasteless. Yes, they are important. Because with

If you ask people who work with data, you will get to know that combining Excel files or merging workbooks is a part of their daily work.Agree?A simple an example:

And after that, I told him about five different methods for this but then he got confused about which method is easy. Even I have created a small UDF to make it super easy for him to remove n number of characters from the start of a string.