After creating a custom function, you can use it in the workbook by activating the Paste Function Dialog, and selecting User Defined. The custom function always embeds itself into this category by default.

There is however a way to store it in one of the existing categories, by using VBA.
See the attached file!

Your new custom text function can now be stored in the Text Category!!!