In this excel VBA example, the date and time are united in the column. The length of the date is 11 characters and the time is 8 characters. The VBA code I prepared to separate them into two separate columns: date and time. You can modify the character lengths and division of your excel VBA […]
This sample is sorting a column items by other column items. You can this process by excel formulas. But,this means a lot of code dump. So I showed you how to do it with excel VBA codes. If you have any suggestions or questions, please leave a . Thank you.
Change the items of any column with the other items. Actually , this is just Ctrl+H function. Of course, you can develop these codes indefinitely. If you have any suggestions or questions, please leave a . Thank you.