When you want to apply a small tweak to the document, it should not take long to Split formula record. This sort of simple activity does not have to require extra training or running through guides to learn it. With the proper document editing resource, you will not take more time than is needed for such a quick edit. Use DocHub to streamline your editing process whether you are an experienced user or if it’s the first time making use of an online editor service. This tool will take minutes or so to learn to Split formula record. The only thing required to get more productive with editing is a DocHub account.
A plain document editor like DocHub will help you optimize the time you need to dedicate to document editing no matter your prior knowledge of this kind of tools. Make an account now and increase your productivity instantly with DocHub!
okay so first of all go down here and right click and select view code then select the name of the workbook youre currently in and go to insert and module then here were going to create a function called split but split is spelled without and i so its splt then open brackets and the input to this function will be a text variable as string and close brackets and enter and that adds in the end function then here type splt again and make this equal to the split function and open brackets and then the input for this is the text variable and close brackets now excel visual basic for applications already has a split function but in order to make it into a formula that we can actually use in the worksheet we need this piece of code here and we cant make the new function be called split with an i because technically that name is already being used here now save and this needs to be saved as a macro enabled workbook so select no and then change the save type to an excel macro enabled workb