Type your first name in cell A1 and your last name in cell B1. Paste the lines of code into the Module1 Code box. Please find the details in the article Ways to convert numbers to text in Excel.
Essentially the function will convert a numeric value into a text string.
You can also use the formula text. Usually you simply need to change the cell format in Excel select your range with numbers press Ctrl1 on the Number tab and select Text in the Category field. It will return the same results. Using Excel formula if cell contains text then sum.