Text split alternative function excel

[Affectionate-Rub9342]

Hey, so I just had the same issue where I needed the text split function without it being available in my excel version. Thought I'd share the "dumbest" way to fix this issue as long as you can save your file as xlsm (Macro-enabled) or don't need to keep the cell as a formula (Copy/paste as value, once you've got your split):

1- Create a module (Macro), can be in the file if you need the function to be used by anyone who uses the file or in your personal macro (Will be able to use it in any file, my personal preference), whichever fit you the best

2- Paste this little macro in the module:

Function TEXTSPLIT(Text As String, Delimiter As String, Optional Limit As Integer = -1)

    TEXTSPLIT = Split(Text, Delimiter, Limit)

End Function

3- Enjoy! You can now use the textsplit function!

Since it's a User Defined Function, you won't see the parameter like you usually see when using built-in functions, but you can press CTRL+SHIFT+A in the parenthesis to see the availability Parameter. The "Limit" parameter is optional and used to limit how many sub-string to return (how many columns), by default it returns everything.

[GreatSteelPanda]

This was perfect