Yes, that is a standard module. Just paste the code in, alone. You do not need to add any other code, like you did here:
Then in your spreadsheet you can use the function like this:![]()
Sub Macro1() ' ' Macro1 Macro ' '
=SplitText(A1,5,10)
or whatever arguments are appropriate.
Bookmarks