To make it simple, I would advise you to do the following:

In the procedure that's calling  the function, I would create a variable that
will hold the result of your function
and then I would concatenate in the following way
Worksheets(1).Cells(1, 2) = "The text  you want to insert  " & yourVar